01-28-2020 08:12 AM
I have a CSV that has hundreds of columns but no headers. This means that I would manually have to add hundreds of columns to the CSV parser snap but this is a huge pain because there are no keyboard shortcuts and I have to manually scroll to the top of the list of columns to click on the “+” button to add a new column. There’s HAS to be a better way. Any help would be appreciated.
01-28-2020 11:54 AM
Maybe you can add a header record upstream, then parse it with headers present?
01-28-2020 12:06 PM
I ended up exporting the pipeline, opening up the .slp file in a text editor, and copying and pasting them into the .json, then re-uploading the pipeline into the designer. Worked like a charm.
06-06-2020 08:53 PM
I did this for a mapper snap 😀
08-31-2021 10:34 AM
@alchemiz @dwhansen-cbg When I tried editing json and adding column field values for csv parser, all the column fields went empty when I re-uploaded the file into csv parser. do you know what might be happening.
here’s a post Editing JSON for CSVParser to add hundreds of headers i have created for the same.
thanks!