Check if a name exists in another file, delete the row for the username if no match found

[hal9k]

Hello!

I got 2 csv files with a number of columns, my problem is pretty simple I guess.

I want alteryx to check if a username from sheet A exists in sheet B, in case there is no match found I want either it to delete the row, in case thats not possible I want it to make a new column in the sheet A with a simple boolean output for a match.

[ponraj · Accepted solution]

You can use join tool to get the desired results.  I can post sample workflow if you can provide me sample data

[bharti_dalal · Accepted solution]

hi @hal9k,

i am attaching 2 methods . you can see the solution attached. I hope it helps

[hal9k]

Thank you very much for the quick answers, much appreciated!