How to loop through 2 datatable and match value based on the column

Help Studio
, , , , , ,
1

Hi all,
I have almost able to get the output… but i am facing change in how to loop through a single cell with alt enter and match with DT2 value…you can refer the outputcolumn in the screenshot…thanks in advance

IMG_20230526_170057
IMG_20230526_1700571920×761 204 KB

2

For Associate, wrt to DT1 it should check and process values may be vice-versa… main thing is DT1 … based on DT1 need to compare in DT2

3

@Bhanu123

  1. Use for eqch row in datatable on dt1 and assign index value to variable …index is present in for loop properties
  2. Inside the loop use unmatcheditems = currentrow("Process").ToString.Split({Environment.Newline},Stringsplitoptions.RemoveEmptyEntries).Except(dt2.Rows(index("Process").ToString.Split({Environment.Newline},Stringsplitoptions.RemoveEmptyEntries)

Unmataches items will be of type array of strings…

You can do unmatcheditems.count > 0 to check if every thing is matched or not…

Cheers

4

This is called a join. Use the Join Data Table activity.