Merge Excel Files with Different formats

[Orchestrator_Practice]

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

[michael.zura (GuardiansFan)]

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

Can you join datatable without duplication?

Hello all! I’m trying to join two datatables which have the same exact columns, have matching rows, but have unique cell values. Table 1: ID | Name | Ticket 1 | John | 2 | Peter | 205 3 | Mary | Table 2: ID | Name | Ticket 1 | John | 301 2 | Peter | 3 | Mary | 564 When I attempted an inner join with matching ID, I got: ID | Name | Ticket | ID_1 | Name_1 | Ticket_1 1 | John | 301 | 1 | John | 2 | Peter | | 2 | Peter | 205 3 | Mary | 564 | 3 | Mary | When I attempted to merge the …

Regards

[Orchestrator_Practice]

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?

[postwick (Paul Ostwick)]

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

[michael.zura (GuardiansFan)]

@Orchestrator_Practice
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

[Orchestrator_Practice]

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.