Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Add Headers & output in a particular Excel tab

mohit9garg
8 - Asteroid

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

13 REPLIES 13
mohit9garg
8 - Asteroid

@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

DavidP
17 - Castor
17 - Castor

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.

mohit9garg
8 - Asteroid

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.

 

mohit9garg_0-1590314730796.png

 

Again many thanks for the solution. _/\_

 

DavidP
17 - Castor
17 - Castor

In the Output Data tool there is an options to skip field names.

Labels