So i am working with this csv and had to remove first 2 row by converting the csv to String list then doing a skip line , this works great because first 2 rows make the csv unreadable due to unstructured data. My end goal is to convert to data-table an using the generate data-table after the skip works great.
Problem:
some of these csv can also have “Duplicate Column” names, this throws off generate data-table by throwing the error: a column name already exist.
Question:
How can i remove this duplicate “Column” name before generate-data table runs ? since its not a data-table yet we cannot use any data table activities. I am thinking some kind of manipulation in the List can be done, i did tried using “Distinct().toList” and is not working. attaching workflow test.xaml (11.3 KB)
