Hi Alteryx Team How to move from this - NameVehicleNumber SteveCar23GeorgeBus3 To output 123NameVehicleNumberSteveCar23GeorgeBus3 Basically I want the headers to move to a Row data and to change the headers to 1,2 and 3. Please help

Output Issue

Hi Alteryx Team

How to move from this -

Name	Vehicle	Number
Steve	Car	23
George	Bus	3

To output

1	2	3
Name	Vehicle	Number
Steve	Car	23
George	Bus	3

Basically I want the headers to move to a Row data and to change the headers to 1,2 and 3. Please help

Workflow

Help

Accepted answers

afv2688

Hello @henrygeorge ,

This should do it

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

add_names.yxmd

All comments

meljaafari

Hi Steve,

the attached workflow would allow you to do that.

I used the Field Info tool to get all your column names as rows (and therefore as data) then cross-Tab'ed it and unioned that with your original data source,

Hope this helps,

Output headers as Data.yxmd

MarqueeCrew

Hi @henrygeorge ,

let me introduce you to my little friend, field info. This tool will output the name (and more) for each field. His buddy is the recordid tool. They are supported by a select tool.

if you configure these tools together, you get:

1|Name

2|Vehicle

3|Number

More you can Cross Tab the data to get 1 row of data with 1,2,3 as your headers and the data is your field names.

now Union this data (as 1st input and force it to always come in first via the checkbox). Now bring your data into that union. The union configuration will be by Field position.

your done!

on a plane ...

cheers,

mark

afv2688

Hello @henrygeorge ,

This should do it

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

add_names.yxmd

vsoni

in addition to the above, on some datatypes you can untick the 'First Row contains Field Names' to keep the row as a data row, and then use a dynamic rename to adjust the field names.

Cheers

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703