Merging Data Tables

[pasimon (Pau Simon)]

Hello,

I’ve been creating an automation where in im going to merge two excels by the use of assigning a primary key to a column. It works fine. But when I run the automation, it also appends the data from the second excel even though there is no primary key on the initial excel. Help!

Thank you

[pattyricarte (Patty Boy)]

@pasimon

What type of join did you use .Can you give more details to easily address the issue.

cheers

Happy learning

[Shriharsha_H_N]

Hi,

You can read all excel files and output datatables. Then use the merge datatable activity.

[pasimon (Pau Simon)]

@pattyricarte

Hi,
I have used assign activity for merging my data tables.

[pasimon (Pau Simon)]

Hi @Shriharsha_H_N,

I have tried this method but doesnt seem to merge the data that I was expecting, thats why i used assign activity in setting the primary keys and merge two dt together.

[pattyricarte (Patty Boy)]

Hi @pasimon
You can share your excel if you want and also screenshots of your output.
I will create a xaml for you.

cheers

Happy learning

[Palaniyappan (Forum Leader)]

Fine
Let me explain you briefly in what can be done for this
—we can use MERGE DATATABLE ACTIVITY where mention the two datatables as input
—make sure that those two datatables have same number of columns, same order of columns, same datatype of columns
—if any of these conditions fail it won’t merge and we will getting error merging them

Merge Data Table

Or

If we want to join those two datatables based on a condition then we can use JOIN DATATABLE activity
For more details on it

Join Data Tables

Cheers @pasimon

[pasimon (Pau Simon)]

Hi @pattyricarte,

I have already resolved the issue. Thank you so much for your response!

[pattyricarte (Patty Boy)]

No worries @pasimon your great

Happy to help here

cheers

Happy learning

[pasimon (Pau Simon)]

Hi @Palaniyappan,

Thank you so much for this. It really helped a lot.

Cheers!