Hello,
I need to map a BOD that has a header/detail structure to a CSV that will have a line for the header and potentially multiple lines for the detail in the CSV file. Can this be done in ION?
Hello Nick
You can use a XSLT mapping in a data flow for this purpose. It must convert your original BOD to a new custom BOD that has a "delimited" format type. The noun MyNewCSVNoun must be repetitive and must contain a number of fields corresponding to the number of columns you need in the final csv file. First occurence of this new noun should contain header data. Following ones should have rows data.
Maybe something like this:
before (ApplicationArea not displayed)
after
When ION send the file in the destination folder, the csvBOD is converted to a csv file. You set up record sep & delimiter in the file template.
Great solution. Another solution is to use the python scripting functionality that also can be used. With the python script you will have even more flexibility.
Thanks so much for this information. Very helpful.
