Get string from a data table

Help Studio
1

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:
dt1:
image

dt2:

image

result should be :

image

2

You must look into join datatable activity.

Regards,
Karthik Byggari

3

You can use for each loop for this

4

thanks, but would you mind explaining this in detail ?

5

Main.xaml (13.8 KB)

Hope this Helps!!

1 Like
6

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
7

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 :-
image

Output :-
image

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

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

1 Like
8

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