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

Hey!

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

・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? :thinking:

Hi,

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

Regards,

1 Like

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!:bangbang:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.