excel

[vijaylnyadav]

I want to create an excel file where I can save the desired output in more than 10 tabs.

how to do that. 

1 excel file and <10 tabs.

any solutions????

[Emil_Kos]

Hi @vijaylnyadav,

This article will provide you with detailed explanation how to achieve it:

http://community.alteryx.com/AlteryxArticle?id=kA0E00000000Vy7KAE

There is also an alteryx workflow as an attachment but I suggest reading the article and you will have perfect understanding how to do it. 

if this was something helpful please mark it as a solution. If you need any more assistance please let me know!

[grazitti_sapna]

Hi @vijaylnyadav , do you have any identifier on which you want to store the result in 10 different tab.

Let's say you have a column source from Source1 to Source 10 then it can be stored in 10 different tabs. Please refer to the screenshots attached.

Config of output tool-

I hope this helps. Kindly mark this post as solution.

Thanks.

[vijaylnyadav]

i am getting many errors as file not found or access denied or sheet already exists

I am using wait until done but still it is showing same error

[atcodedog05]

Hi @vijaylnyadav 

Configure output tool to overwrite sheet or range

This will resolve sheet exits issue.

Other issues share a snapshot we can help you🙂