โ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!