I have 3 outcomes of a Alteryx Workflow. I need to add different headers in each outcome and then need to extract them all in a single excel tab and in a particular cell.
Example is attached herewith.
Thanks in advance.
Mohit
Solved! Go to Solution.
@deviseetharaman @grossal @DavidP
I would prefer to use OUTPUT tool as I need to give excel tab & cell details which is not possible to use RENDER.
Is there anyway to give any reference or header to each outcome, which can be saved through OUTPUT tool.
Regards,
Mohit
Hi Mohit,
To do this, I would write the header and data with separate output data tools, as in attached example.
You can also specify the cell range to write to in older versions of Alteryx like this:
C:\Users\david\Documents\Alteryx\outputfile.xlsx|||Sheet1$B2:B2
This would write to a single cell.
Thanks @DavidP This is very smart way move. 🙂 This can resolve my issue.
One last very silly ask-
Below the the output of your workflow. Can I remove this "Field1". I tried to kept it blank but seems its mandatory to have some column name.
Again many thanks for the solution. _/\_
In the Output Data tool there is an options to skip field names.