Add a row above header

[videet]

I have a table like below with headers(In English) name, email, id, hire date.

I want  to add header with local language name above English headers name

Input

Name	Email	ID	Hire date
a	p	1	25-06-21
b	q	2	26-06-21
c	r	3	27-06-21

In output table i want to add one more header in local language along with English headers

Output

Nome	E-mail	ID	Data di assunzione
Name	Email	ID	Hire date
a	p	1	25-06-21
b	q	2	26-06-21
c	r	3	27-06-21

I also have mapping for it

Local	Eng Names
Nome	Name
E-mail	Email
ID	ID
Data di assunzione	Hire date

Any idea how it 

[apathetichell]

So Alteryx doesn't have multi-row headers so there are basically two ways:

1) union in the new set of rows before an output. This changes the format of your data.

2)  nested tables. This is harder but keeps your data in the right format on render to excel.

Here's an example of the second solution...

[AkimasaKajitani · Accepted solution]

Hi @videet 

I made sample workflow.

The weak point is that the data type converted to string.

Result:

[videet]

@AkimasaKajitani 

It there any way we can change data type to previous what was original

[apathetichell]

In alteryx or in excel? In alteryx the short answer is no - you need everything in the same datatype in a column and that's string if it's numbers and characters.  Two week ago I recommended nested tables which should keep datatypes when rendered into excel.

[atcodedog05]

Hi @videet 

Here is how you can do it. The trick is to first write first set of headers and then write actual table from 2nd row.

Workflow:

1. The first branch output tool is writing the local headers.

2. The second branch output tool is writing the actual table from 2nd row and datatype remains same.

Output:

As you can ID is numeric.

Hope this helps 🙂