Multiple file of excel, unify in one file but with more sheets

[Danilo9017]

Hi Guys

I am struggling to find a solution for my workflow. I basically have three final table : 

"input 28-07-2022 France"

"input spain test 28 07-2022"

"Input 28 07 2022 italy test"

I need to unify these three files in an unique file but in different sheet for each file (sheet italy for "Input 28 07 2022 italy test", sheet spain ""input spain test 28 07-2022" and sheet France for  "input 28-07-2022 France" . The final output file should be a google excel sheet (gdoc) 

Attached also my desidered output. (on excel file format..but i would need a googl sheet format)

Guys do you know if Alteryx can do it? (i used the google sheets output tool but i am struggling to combinate all the files )

Thanks 

Danilo 

[christine_assaad · Accepted solution]

Hey @Danilo9017 

Please see attached solution. Cheers!

You can leverage the Output tool to generate sheets based on your data.

Edit: Sorry I missed the gdoc part

[binuacs]

@Danilo9017 One way of doing this with the batch macro

[Danilo9017]

Thanks Christine

It works! 

Danilo