CSV Headers
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?

How can I fix this issue in the ecl code?
- mo0926
- Posts: 18
- Joined: Thu Jan 09, 2020 3:57 pm
mo0926,
HTH,
Richard
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.How can I fix this issue in the ecl code?
HTH,
Richard
- rtaylor
- Community Advisory Board Member
- Posts: 1619
- Joined: Wed Oct 26, 2011 7:40 pm
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?
Does that make sense?
- mo0926
- Posts: 18
- Joined: Thu Jan 09, 2020 3:57 pm
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
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
- rtaylor
- Community Advisory Board Member
- Posts: 1619
- Joined: Wed Oct 26, 2011 7:40 pm
5 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest