Filtering Data Table and Adding Match

Help
1

Hi

I have two sets of data:
dt1:

Column A Column B Column C
Data 1
Data 2
Data 3

dt2:
|Column 1|Column 2|Column 3|
|Data 1a|XYZ|XYZ|
|Data 2b|ABC|ABC|
|Data 3c|ABC|ABC|
|Data 4|ABC|ABC|
|Data 5|CDE|CDE|

I am trying to use a data filter so that if dt2 Column 1 contains an entry in dt1 Column A i want to copy the entry into a new “Match” column in dt1. So in the above scenario the first rows for each should match. I want to copy “Data1a” into the match column.

2

you can try with Lookup Data Table

3

Hi @DataUser

So though you are looking for match, there is a slight difference at the end of that string because you have some additional characters in DT2. I have actually created a sample workflow which can be used in such cases. This can be helpful for you in getting it sorted.

MatchTwoDataTables.xaml (9.4 KB)

Let know whether this helps you to sort it out… If it works, make sure to mark my answer as the solution too…

2 Likes