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

3 Replies

  • mina's avatar
    mina
    Employee

    Hi Sijo,
    the error says
    java.nio.file.AccessDeniedException: \server.net\server-files\IT\Dev\DO370\Dev\2019\08\26\input\1.json
    Could you check if the account used to launch jcc has access to the input file?