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 have a workflow that produces 4 tables from 1 excel file then I would like to put them together into one excel file as a 4 worksheets + I want to add 2 worksheets from another excel file to have 1 excel files with 6 worksheets, which 4 comes from tables made by workflow and 2 which comes from another excel file. How can I do something like that?
If they have the same schema you can use one output tool.
If they have different schemas you would require one output tool per stream.
Each stream would need to be blocked to prevent a 'write' conflict with Alteryx (i.e. so it writes one sheet at a time and doesn't try to write two at a time). This can be achieved using the parallel block until done tool available on the Alteryx gallery.
Check this post out it should give you some pointers (ignore the piece about the R tool it should not be relevent in your case).
First: In one table there were number headers like 1,2,3,4 now they are X1,X2,X3,X4.
Second: In each table If there was a header with two words like "name surname" in the output tables each header is like "name.surname". Headers with one word are good. Only headers have this issue, values in each column are good.