CSV Headers

[mo0926]

Hello I hope someone can help with this. I recently created a build that generates stats that eventually get used in Power Bi. I need to layout the headers nicely for the Power Bi import. However, right now when I export to csv from the ecl watch, it only converts with 2 columns rather than 7. It looks like when I am writing the csv file it only creates 2 columns: column 1 and line1 with all of the data in line1.

How can I fix this issue in the ecl code?

[rtaylor]

mo0926,

How can I fix this issue in the ecl code?

Without looking at your code, the only suggestion I have is that the problem most likely lies in the RECORD structure of the record set you're writing to disk.

HTH,

Richard

[mo0926]

It hard to explain without visuals. I can't share the data. The outputs are fine in the ecl watch. The headers there checkout, but once you export onto a csv everything that used to be divided into 7 fields for example: datasetname, logicalkey, prev_version etc .... it is crunched together in line one: field line[datasetname, logicalkey, prev_version, etc..].

Does that make sense?

[rtaylor]

mo0926,

I don't need to see the data, but I would like to see your ECL code. You can send it to me in an email if it's company confidential.

Richard

[mo0926]

Sure, will do. Thanks.