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

Question

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 Answer

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 Answer

hi @hal9k,

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