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
Hi Pedrodrfaria,
Thank you for your quick response! Attached the output file I would like to get. If the restaurant is in the all three input files, I would like to get an output files with the variance data for each input.
@Jmaldonado
Made some modification based on the work of @pedrodrfaria .