This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I don't think I was clear enough in my question-- I want to be able to to have TWO different data sources go into teh same excel file, each under their own tab. Does that make sense? So, I have a fork in my Alteryx stream, and currently have two different outputs, which right now have to go into two different excel documents. I want them to go into the same excel document, but with different sheets. The data are in different structures, with different fields, etc. The example you shared has data from a single stream being divided by a variable field.
So, if I have multiple inputs and union them together then split them on the common field, I get each group in a tab, but it forces every tab to the same layout. I had a process in Alteryx 8.6 where for each file stream i used the table tool and grouped on my common field, then a layout tool that grouped each set of records on my common field with orientation Vertical with section breaks. I unioned all of my Layout outputs together and then used the render tool and output to a file. it would then create an excel file with multiple tabs and the tabs would be named based on my common field. In the version 9, the file still creates the distinct tabs but now it has generic names sheet1, sheet2, etc.
I need to retain the unique layouts for each file and name each of the tabs based on my common field. Any thoughts?
Hi @MikenN, I tried this solution and was ok, but when I ran with my outputs I had this error
"Output Data (193) Unable to make final write to C:\Users\cuevasaz\Desktop\XXXXX\Collection\PROYECTOS COLLECTION\Nuevos proyectos\Reportes ALTERYX\Publico\OutputtoDifferentTabs.xlsx, Error Win32 Error 1175"
My file (,xlxs) has 3 sheets and the error send me only in the 3rd sheet