I have created a dataset for a CSV file store in ADLS. It has got two different columns with same header name [Parent_ID]. Beacuse of it I am getting error while mapping it to the sink.
Also the header start from 2nd row, and the dataset is not able to detect column names correctly. I tried using additional column option but it didn’t work as the column names detected by dataset are not available.
I want the first one to be [Parent_ID] and second one to be [End_User_Parent_ID] in the Sink.
I am not allowed to use Dataflow in this case. How to handle it?
New contributor
Ankit Jha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.