Urgent help with delimited

[Navya08]

Can someone help me -i want to check sheet 1 column b and d with sheet 2 column b - compare all ids are present in sheet 2 the onlyy problem  i am facing is i am having ids delimited  by "," i have to check all these id's- basically reconciliation among two sheets. also i need all details as well in my output sheet i.e other columns as well

[OTrieger]

@Navya08 

I assume that you will know how todo it if there would not be delimited values.

[OTrieger]

Filter out all the rows that contains comma, then with Column to Text split to rows. Do what you did with the usual values. 

The easiest way to get all the data, just assign a RecordID after importing the data, and when you finish with your validation of the codes, just Join by recordID and you will have the data back

[OTrieger]

For sheet1 you can make a condition that if D is Null then take B value

[Manoj_k · Accepted solution]

Hi @Navya08 i have attached the workflow for your reference