Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi, I am currently planning to generate multiple excel files and tabs based on two columns. The idea is illustrated as below:
Does anyone know how to generate output as above? Preferably with the naming as well (i.e., not the default name of the output sheet e.g. Sheet 1, Sheet 2 etc.). Thank you in advanced !
Solved! Go to Solution.
Hi !
I have solved the issue. The first layout grouped by bookstores and genre, however, this would lead to separate excel files, but all the tables are included in only one tab (i.e., Foyles.xlsx has a tab that consists of tables for Mystery, Horror & Romance).
Hence to get around it, I have included another layout tool that only grouped the table by bookstores. This would separate the genre tables to different tabs.
I have attached the workflow for your reference. Really appreciate everyone's help on this ! Thank you !
