Csv to datatable problem

[erimbetul (Betül Erim)]

Hello,

When I read an Excel file that I can only download in CSV format using the “read csv” activity, I cannot convert it to a datatable due to duplicate columns. How can I solve this issue?

[Parvathy (PS Parvathy)]

Hi @erimbetul

You can read the CSV file by unchecking the Add Headers option in Read CSV activity.

Regards

[erimbetul (Betül Erim)]

yes but i need that column names after this step how can i make the first row as column headers again?

[Anil_G (Anil Gorthi)]

@erimbetul

you can loop through the columnd dt.Columns and then inside loop use if condition to check if already the same column name exists…if no use currentitem.Columnname = dt.Rows(0)(currentitem.Columnname).ToString…on yes side use currentitem.Columnname = dt.Rows(0)(currentitem.Columnname).ToString + "_1"

I hope only one duplicate if multiple can handle accordingly

cheers

[singh_sumit (Sumit Singh Tariyal)]

Hey @erimbetul Instead of using read csv can you use Excel application Scope and inside use Read range activity and uncheck the header option this way you can also read that file.
might be it not showing file when you try to select file using the excel application scope insted copy that file path and paste in the excel application scope then use read range
cheers

[mkankatala (Mahesh Kankatala)]

Hi @erimbetul

Unselect the add headers option in read CSV activity properties. Then make the first row of datatable as columns.

Check the below thread to make first row as columns of a datatable,

First row to be column in Datatable

@mkankatala Use a for loop with dt.Columns and change type argument to datacolumn Inside the loop use currentitem.ColumnName = dt.Rows(0)(currentitem.ColumnName).ToString After the loop use assign to remove the first row as below dt = dt.AsEnumerable.Skip(1).CopyToDataTable Or use remove data row activity Hope this helps Cheers

Hope it helps!!