Hello,
I am new to alteryx and I have two input files. File1 has a list of id numbers (generated each day) and other file (file2) also has a list of same or more id numbers (but in 2 different tabs). I need to compare id # from file1 with those in file 2 (in 2 tabs) and for any matched id's (in file2), I need to move those rows from tab1 or tab2 to 3rd tab of file 2. I have attached a sample workflow screenshot. I am not sure of moving rows from one tab to another tab. Please help.
Thanks
Hi S_N,
I put up a solution for you. Basically, I joined tab 1+ tab 2 in the file 2 through the dynamic input tool and after I made the check versus file 1. The common records found, I output into File 2 ticking the option Create new sheet. Hope it helps! Final file 2 in the attachment .