Urgent help with delimited

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

alteryx question help.xlsx

Input

Date Time

Help

Accepted answers

Manoj_k

Hi @Navya08 i have attached the workflow for your reference

ID CHECK.yxmd

All comments

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

Hi @Navya08 i have attached the workflow for your reference

ID CHECK.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703