Adding a new row with differing text in each column

Question

Hello!  I have a workflow that is taking a report and performing a calculation.  I want to add one row above the headers of the output table that show what the inputs are and what the calculations are for each column.  So say we have column headers: column 1, column 2 and column 3.  I want to add a row above the headers to identify column 1 as "A", column 2 as "B" and column 3 as "A*B".  Is this possible?

Thanks in advance!

Christine_Assaad · Answer

Hello @lindsayhupp

Is the below what you are looking for?

If yes, I did it using Alteryx reporting tools to create 2 tables, stack them vertically and then output everything to Excel. Hope that helps.

Cheers!

Add a row with different header.yxmd

FrederikE · Answer

What you ask for is not possible, bc, Alteryx only allows one header.

But if you can do this is mostly depended on what kind of output file you want to have. Filetypes like .xlsx or .csv don't know headers and therefore it is no problem to do a workaround. If you want to write smth. like a .hyper file which knows headers this won't work.

You can extract the header of all columns using the "Field Info" Tool, followed by a cross tab and then union it with the text you want to add. Then the Text on top has to be the header -> dynamic rename.

WF attached.

New Workflow2.yxzp