Ok, so actually i have a csv file where there are two columns with the same column name “Source [list]”. I need to apply filter and remove some others columns. So what i am supposed to do is Read CSV -> Filter Data table -> Write CSV.
If i start doing this with the raw file then it will error out as data table won’t take two columns with same column name. So before Read CSV i have to open the csv file through Excel Application scope and do select whole header row -> Ctrl+F ->Type Source [list] -> Find Next ->Type Source [list]1 -> Click Replace -> Save workbook.
Then Read CSV-> Apply Filter -> Write CSV.
Then again open the same file using Excel Application scope. Do the above stuffs again and rename back the Source [list]1 to Source [list] and Save workbook. So here its changing the file format and bringing all the columns to a single column.