cancel
Showing results for 
Search instead for 
Did you mean: 

Repeat Target Path/ Header Name in a csv file

cbot412
New Contributor II

Hi,

My CSV has headers which repeat themselves - BLANK2 , BLANK2, BLANK2 , NAME, BLANK2

Mapper gives me error saying that I can’t have same Target Path names. I tried adding header fields to CSV formatter and Binary Header, that didn’t work. I tried adding .string() after the field name- didn’t work

I am thinking of a very convoluted way of doing this, but wondering if there is an easy fix that I am unaware of.

5 REPLIES 5

koryknick
Employee
Employee

Please take a look at the CSV Parser documentation. There is a secondary input view that you can use to replace the column header names so that it will parse correctly.

cbot412
New Contributor II

Thank you! I get the headers but it skips all the blank columns.

my headers are

name, id, blank, blank, school, blank, blank.

and I have the blanks in the data and schema, but once it comes out of parser, it gives me

name, id, school

and the blank is not there anymore.

koryknick
Employee
Employee

Please provide a sample of your input file and desired output. We need to understand your requirements to assist any further.

cbot412
New Contributor II

Thanks so much!

I am attaching the file that I am uploading for headers, and the output we get, and the expected file. I have also attached two screenshots of the pipeline I have.

The data in there is dummy so it might not be consistent
ExpectedFile.xlsx (17.0 KB)
Header.xlsx (16.9 KB)
OutputIamGetting.xlsx (16.9 KB)

Screenshot1
screenshot2