I want to compare two datatable and put them in a new datatable

[ri-na (r t)]

Hey!

I would like to do this with uipath.
But I am a beginner and have no idea what to do.

・If A has the same title as A and B is not blank
・Has the same title as A, but item B is blank
・Write the result to a new datatableC

Can someone please teach me how to do this?

[Yoichi]

Hi,

There are some ways to achieve this. One of them, we can use LeftJoin. The following will help you.

Looking Assistant with excel

Hi, In this case we can use LeftJoin in JoinDataTable activity. Then remove unnecessary columns and sort, if necessary. [img20220325-1] Sample20220325-1.zip (15.2 KB) Hope this helps you. Regards,

Regards,

[ri-na (r t)]

Hello Yoichi!

I did exactly what you said and it was executed perfectly.
All I did was delete the blank item column and convert the column name of item_1 to item.

Thanks very much for the great result.

Thank you!