Forum Discussion

hina_walia's avatar
hina_walia
New Contributor
6 years ago

Same column names in dat file

Hi, I have pipe limited dat file. I am using csv parser to get columns. The dat file has same column name(description) more than once but value is different eg- id name company cd descrip...
Kulashekharan's avatar
Kulashekharan
New Contributor II
6 years ago

Same column name in a CSV will over write the previous key with same name, hence will retain the last column’s key and value only. CSV doesnt expect an Array.
If the number of columns are fix, you can do the following

  1. Use Skip Lines = 1 (skips Header row)
  2. Uncheck Contains Header
  3. Added the Column Names this time with some difference in the column names:
    Example: ID, Name, Company CD, CompDescription, Job, JobDescription, Department, DeptDescription, OrgUnit, OUDescriptin

the Names within an object should be unique so you can clearly identify them. If they can repeat then they need to be an Array or array of objects

  • hina_walia's avatar
    hina_walia
    New Contributor
    6 years ago

    Thanks . It worked