How to merge columns from different DataTables in UiPath - Tutorial from Start to Finish

HI Anders i like your video, i have a query .from 3different excel file every sheets contains different regions and item code how to seperate in ui path and extract in single file but different sheets ,sheets are containg different regions like America,Africa,Europe

Big thank you! This is extremely helpful. and you explain it so well!

Another great video! I've done two tests on this with my data, one using this method and another using the 'Merge DataTable' activity. Are there any advantages for using one over the other?

how to merge two column of same file.

As expected, another great video!

Please Help to Merge Two-column in the same Excel sheet.

@Anders not working for after 5 iterations throwing exception both data tables having 15 items one datatable having 2 columns and other having 1 column trying to merge using your code not happening

Can you explain the difference between join data table and merge data table? This reply is important for me Anders

You are the best Anders. Thank you

Thank you for your videos as always Anders!!
Manuel.

If anyone deserves thanks, it's you! @Anders.

Okay! In the same situation if we have "serial No" in first column for both sheet 1 and 2.
Then how to skip that column from 2nd sheet.
Because we don't want to write that "serial no" column in 3rd sheet as double.

We want like this:-
Serial no,Name,Age,dob,address,city,zip.

In that scenario? What we have to do

Tq Jensen very useful video