Merge Excel Files with Different formats

Hi Community

I have three input files and I am trying to merge them to match the output format in the Desired Results file. Not having any luck in matching the format of the desired results format.

Input_1.xlsx (10.1 KB)
Input_2.xlsx (10.2 KB)
Input_3.xlsx (10.1 KB)
Output_Desired Results.xlsx (10.2 KB)
Thank you

I think with a little looking around this forum, the same question was asked, here is a starting point:


Yeah, I saw those too. But my example does not have the same columns in each file like the examples in the forum. Wondering if this is even possible in UiPath?

Read each one into a datatable. Alter each datatable to the format you need. Merge Datatable multiple times to combine them all into one.

Build Data Table with required columns as dt_New
Join inputs 1 and 3 by ID to dt_New
Join dt_New and Input2 to dt_New
Filter Keep Columns you want

Not sure this process will scale or be flexible to handle more uncertain data. Since the inputs are irregular, this process might not be suited to automation.