Deleting values that appear in another tab

[AbhishekkSinghh]

Hi, 

I am fairly new to Alteryx. I have created an Alteryx workflow that reads from an input excel file with only one data tab and creates and output excel file with three data tabs. 1) TrueParent 2)TrueSub 3)Misc.

Values in TrueParent Tab is present in TrueSub and Misc Tabs of the same output excel workbook. Without having to read that output file as an input file, I want to do the following:

Look at 1)TrueParent Tab and if the values from this tab also exists in 2) TrueSub and 3) Misc Tab, then delete these values from  2) TrueSub and 3) Misc Tab.

TrueParent Tab( Example)

ABC_12

X_3YZ

MNOP87

TrueSub Tab(Example)

X_3YZ (this row will need to be deleted)

HelloWorld

ABC_12 (this row will need to be deleted)

Misc Tab(Example)

MNOP87 (this row will need to be deleted)

Misc1

123Misc

[AbhishekkSinghh · Accepted solution]

Dear All,

I found a solution myself. And for future reference I will post it here.

I used Join Multiple tool to bring in all the column as one table and then used formula tool stating if value from TrueParent=TrueSub then 1 else 0, then I only took 0's using Filter tab and then using select tool, removed columns of the other tab. I had to do it twice one for TrueParent and TrueSun and then TrueParent and Misc.

Hope this helps anyone trying to solve similar problem.

Regards,

Abhishek Singh