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.
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.
I did this for a mapper snap 😀
@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!
Maybe you can add a header record upstream, then parse it with headers present?
