Multiple Excel Sheets

[Kallis]

Hi

I need to create separate Excel sheets in a single workbook for every company code country. 

Kindly help.

Please note that number of countries will vary.

Regards

Bobji

Input

Company Code Country	Invoice Document Date	Base Line Date	Archiving Date	Changed Date	Vendor GUID(SIM)
US	20200309	20200210	00000000	00000000
UK	20200309	20200211	00000000	00000000
IN	20200417	20200420	00000000	00000000	00000000000051046864
IN	20200417	20200421	00000000	00000000	00000000000051026805
US	20190402	20200508	00000000	00000000	00000000000050505761
US	20160217	20200701	00000000	00000000	00000000000050474000
UK	20161013	20200701	00000000	00000000	00000000000050474000
UK	20161027	20200701	00000000	00000000	00000000000050506214
DE	20160526	20200701	00000000	00000000	00000000000050506555
DE	20160525	20200701	00000000	00000000	00000000000050506555
BE	20160526	20200701	00000000	00000000	00000000000050506555
BE	20160604	20200701	00000000	00000000	00000000000050506555

[abacon · Accepted solution]

@Kallis Follow the instructions on the below thread, this is exactly what you are looking to do.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Group-output-into-seperate-she...

[JosephSerpis]

Hi @Kallis there is also a Alteryx knowledge base article which tackles this challenge.

[Kallis]

Thanks @abacon 

It worked like a charm

[Kallis]

Thanks @JosephSerpis