Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Only possible best way I can think of is by using reporting. Convert all the sheets to tables and output them to each sheets using a single render tool. In this method, each sheet is written one after other in a single tool hence it doesn't create write block,
Why Single Output tool doesn't support this?
Output tool expects you too have same columns for sheets hence doesn't.
How Reporting tools support this?
Since at the end there is only one column that table the actual data column doesn't matter.
Note: one drawback is all sheet will have the same width and there is nothing that can be done.
Hope this helps : )
Hi @GayatriPanigrahi ,
Do you run the Workflow in Alteryx Engine? If you use the AMP Engine, please change to the Alteryx Engine(don't use AMP Engine).
It is difficult to use the UBD in AMP Engine.
Or do you try to use Parallel Block Until Done in Crew Macro?
http://www.chaosreignswithin.com/p/macros.html
The last method I can think of is to use a batch macro.
Each data into specific sheet must be Name & Value Fields with Sheet and Record ID field.
After that, you put the data into the Batch macro, you need to recover the data by using Cross Tab tool and save them in the Batch Macro for each sheet.
Batch Macro:
In any case, you can use this macro with a light fix.
Please check the attached workflow.
If you have any question, let me know.
