My input file is one, however i am getting 2 different output or more depending on my selection. But i need all output in one excel tab/sheet wise. Is that doable in alteryx?
@ilovecoding This can be achieved by using either block until done tool or based on a column in the input file, below post has the two approaches mentioned
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-write-to-different-tab-on-same-excel-file/td-p/572193
@ilovecoding ,
ok, you simply need to build the dynamic fullpath including the sheet names and then change the config of your output tool.
In the attached example I've built the following:
So you now have a fullpath with the tab names.
Then configure the output tool as follows:
I hope this helps,
M.
Hi @ilovecoding ,
Yes.
If you would like us to help with your specific example can you post some mock data representing your input(s) and the required outcome?
Hypothetical example, the below 2 output i need in sheet1 and sheet2 of same excel output file.
