I am approaching the problem using the following method.
1.Creating a datatable (dt) with the filename
1.Reading data from csv into another datatable(dt_csv)
now I wanna join those two datatables in such a way that first column value in every row is the filename.
Finally, I am storing it in another csv file.
I am open for any other approaches as well.
Thanks in advance
to reorganize that
just use a filter datatable
input dt as it is
Just add column sequence in Keep Columns section, as you want, output datatable will be the one that you need.
@rahulsharma How to filter or select the column which is required to join?
Assuming that the filename is available in dt_csv datatable.
I declared a variable column_name as āfilenameā
Just in place of Filter. I am using Invoke method activity and using SetOrdinal Method inside it to set the required column at the first position. So, Even if there are few more rows in my raw_data file I wont have any issues in the future.