Matching variable in 2 datatables

Help Activities
, ,
1

1st table: csv

2nd table: xlsx

I have to compare this two files and match the reference id. Check if ABCD123 appears in both files, and check the YesOrNo, if is yes, update the xlsx attending column to yes

image

2

Hello @lllqw ,

Perhaps workflow this might help you:

image
image1402×1722 250 KB

The main activities you should use are:

Hope it helps!
Best regards,
Marius

3

what about not based on current row but the value in both data table?

4

Hi @lllqw ,

Maybe also an alternate method would be to use Join Datatables Activity with Left Join. Then update the Column “Attending” using Data Column Expression since it is a relatively simpler updation.

image
image959×529 23.4 KB

Check the workflow below :
DT_Join_ColumnValues.zip (9.3 KB)

For simplicity purpose, I have used both the data as xlsx, you could use the Read CSV Activity for reading the csv files in your case.

You could also refer the Blog below for more info on Updation of Datatable values :

Let us know if this doesn’t help.

5

Hey @lllqw Try this workflow
This will surely help you
Compare column.xaml (7.4 KB)

Try to change the sheet names

Regards

Sreejith S S

6

Hi thank you, Can i ask what does the if else statement part mean?

7

Yeah sure.
if yes is present in the first table then we will update yes in the second table if not then no will be updated. This conditions will be updated only if there is a match between two tables

Hope it helps you.
Please mark it as solution for future reference for other members in the community.

Regards

Sreejith S S

8

hi, can i have your excel files

9

Sorry i deleted them

10

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