03-26-2020 02:14 PM
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
description
job
description
department
description
orgunit
description
The issue is when i do csv parser and preview data, i get description column only once (which is first in place that is after company cd) . The description column after department and org unit does not appear while doing preview. Can you help here. If i try to convert dat manually in csv(pipe delimited) , i get all columns but pipeline somehow skipping it.Please advise
03-27-2020 11:37 AM
Can anyone please help?
03-28-2020 02:44 AM
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
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
03-31-2020 01:41 PM
Thanks . It worked