Get string from a data table

hi friends

i need to check if a row string of one table exists in another data table and get the string if exists and write it into excel. Do you have any idea.

for example:



result should be :


You must look into join datatable activity.

Karthik Byggari

You can use for each loop for this

thanks, but would you mind explaining this in detail ?

Main.xaml (13.8 KB)

Hope this Helps!!

1 Like

As you have a common filed(column i.e. Order No) between two table so you can use UiPath.Core.Activities.JoinDataTables activity to get the required data in the resultant table.

1 Like

Hi @oshan

Below is the workflow for the same.
MainPratik.xaml (13.1 KB)
Dt1.xlsx (9.4 KB)
Dt2.xlsx (9.5 KB)

Input :-

Output :-

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

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