I'm pretty new in Alteryx and I would like to know if it's possible to input three files and if the RESTAURANT # repeats in the three files, then add the whole line to an output file.
Hi
You can use union tool to put all three files together and then take sum of "variance" group by state and restaurant $ using Summarize tool .
Best Regards
Arundhuti
@Jmaldonado
Made some modification based on the work of @pedrodrfaria .