I'd like to add a row/cell with text above the headers in my new table

[assmundsonc]

I'd like the 'Portfolio Template' in cell E1 and have all of the headers in row 1, to be in row 2 - but I can't manage to get them to swap around.

Thanks for your help in advance.

[OTrieger]

@assmundsonc 

Filter that row out then union them back  Just ensure to select union by position and not by name. At the bottom you can decide the order which text will be first and which second. This is only one way how to do it.

[Gaurav_Dhama_]

Try this

[davidskaife]

Hi @assmundsonc 

Just because there are multiple ways of doing something, here is another approach for a laugh:

Add in a RecordID tool, then in a Formula tool switch ID 1 and 2 around (i.e if RecordID = 1 then 2, or if RecordID = 2 then 1) and finally use a Sort tool to re-sort in ascending order

[assmundsonc]

Apologies, I could have been clearer.

I have a table, which I have then tried to Union that one cell into - like this:

[Gaurav_Dhama_]

You can still use any of the above approaches to get the output. Add it just before your output data tool.

[assmundsonc]

Thanks - it isn't counting the headers as a record row:

[davidskaife · Accepted solution]

@assmundsonc 

Try this:

Use the Field Info tool to get the names of the columns, add in a RecordID and Cross Tab tool to switch the column names into a row. Then Union this output, the field you want to add, AND the original stream together - configure the Union tool by position, and change the output order to stream 2, 1, 3 (note i've manually configured it but the main part is obtaining the field names)

[Gaurav_Dhama_ · Accepted solution]

Okay so you will need to get your headers into first row. Check the attached workflow. While outputting your data, skip headers in your output data tool.

[assmundsonc]

Thanks All!!