Repeating Tools

[Jmaldonado]

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. 

[pedrodrfaria]

Hi @Jmaldonado 

Please see the below workflow attached.

Thanks,

Pedro.

[Tyro_abc]

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]

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. 

[Qiu]

@Jmaldonado 
Made some modification based on the work of @pedrodrfaria .