Is there a way to make the column header the same as the column value. The reason I need to do that is for dynamical updating an app parameter via an import and it want to be able to see the zip code. Example below. 123456234563421334345237787565432452 234563421334345237787565432452234563421334345237787565432452 Might not be possible but any help is appreciated. Thanks

Make Column Header The Same As Value

Is there a way to make the column header the same as the column value. The reason I need to do that is for dynamical updating an app parameter via an import and it want to be able to see the zip code. Example below.

1	2	3	4	5	6
23456	34213	34345	23778	75654	32452

23456	34213	34345	23778	75654	32452
23456	34213	34345	23778	75654	32452

Might not be possible but any help is appreciated. Thanks

Workflow

Tips and Tricks

Accepted answers

jdunkerley79

You can use a dynamic rename tool to do this.

The only slight complication is that you need to duplicate the first row to keep it as well as renaming.

My approach for this it to sample and then union back to the original data.

Sample attached

Rename to first row and keep.yxmd

jdunkerley79

I suggest targeting to replace a specific string:

The list will then be put inside the IN brackets.

As I had basically built it have attached an end to end sample

Rename to first row and keep.yxzp

All comments

jdunkerley79

You can use a dynamic rename tool to do this.

The only slight complication is that you need to duplicate the first row to keep it as well as renaming.

My approach for this it to sample and then union back to the original data.

Sample attached

Rename to first row and keep.yxmd

bryan_ram2613

Ahh beautiful. Thanks for that. I didn't think about the Sample tool. One more question. I want to use that output to run a connected app. Issue that I see is Alteryx isn't reading it as a header. I am getting the your input needs to have a name and value. Is this something you have come across before?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703