Thu Jan 21, 2021 8:49 am
Login Register Lost Password? Contact Us


CSV Headers

Questions around writing code and queries

Thu Dec 17, 2020 5:51 pm Change Time Zone

Hello :D 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?
mo0926
 
Posts: 16
Joined: Thu Jan 09, 2020 3:57 pm

Thu Dec 17, 2020 6:31 pm Change Time Zone

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
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1573
Joined: Wed Oct 26, 2011 7:40 pm

Thu Dec 17, 2020 6:43 pm Change Time Zone

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?
mo0926
 
Posts: 16
Joined: Thu Jan 09, 2020 3:57 pm

Thu Dec 17, 2020 6:47 pm Change Time Zone

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
rtaylor
Community Advisory Board Member
Community Advisory Board Member
 
Posts: 1573
Joined: Wed Oct 26, 2011 7:40 pm

Thu Dec 17, 2020 6:51 pm Change Time Zone

Sure, will do. Thanks.
mo0926
 
Posts: 16
Joined: Thu Jan 09, 2020 3:57 pm


Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron