Hi @grossal @DavidP
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
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.
In the Output Data tool there is an options to skip field names.
Hi @mohit9garg,
maybe @DavidP has a better idea, because I am not quite sure what's the best way to achieve this.
Exporting data to specific cells or ranges is no problem with the output tool, but the header issue will remain. Usually I'd do all the formatting in the Reporting tools but I don't see a way to write the Export to a specific cell with the Render tool.
Sure, you could use two Output-Tools and write Header and Data differently, but I think you are not able to have Header Cells that span over two columns (or more) with that. You would also need a Block-Until-Done tool for this. It's probably the closest to your solution from my point of view. Maybe David has something in mind.
Sorry for the no-show to your tag last time. I have been busy preparing Alteryx Workshops at work lately and did not find the time to check my community notifications.
Best
Alex
You have a couple of things to consider.
If you're writing to an existing Excel file, you have to use the Output data tool, since the Render tool will completely overwrite any existing Excel file.
The Output data tool can't create merged cells, but can write to them if they already exist. Also, since 2020.1 you can now retain any cell formatting when overwriting data in a sheet or range.
If you were to use Output data tools to write data to specific cells, you'd have the generate all of it as data rather than column headers and set the Output data tool to write the data only without headers.
I'm attaching an example of how you can create merged headers with a combination of Table and Text tools. You can also use empty Text tools (containing just a space) to insert rows and columns between and above tables. It will be tricky to manipulate the tools to get the data to the exact cells you want, but it's doable.
Hope this helps.
