Alternative to Transpose tool, but without caching field names

Hi,

Is there any alternative to Transpose tool I can use to have column names in one row, the reason why I can't use Transpose tool is because of the following behavior:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Bug-Unexpected-behavior-Transpose-Tool-caches-field-names/td-p/118552

I need to transform column names to one column "Column_names" with column names as values, but column names may update with each file processing (they also may differ because of capitalization only), that is why I can't use Transpose tool, which caches the columns names and if for example: my column name changed from "Mehod NAME" to "Method Name", the output of Transpose tool still shows Mehod NAME.

Thanks in advance!

Oksana

Bug

Apps

Accepted answers

danilang

Hi @OksanaBezpyata

Look into using the field info tool, found on the developer palette

The column names show up in the name column of the result, with no caching between runs

Dan

FieldInfo.yxmd

All comments

grossal

Hi @OksanaBezpyata,

would Python be an option for you?

Best

Alex

OksanaBezpyata

Hi @grossal ,

Thanks for the suggestion. I doubt that Python would be an option, I launch the application in Alteryx Gallery and from what I see Python tool is on the Alteryx Analytics Gallery list of prohibited tools. Applying for exemption is not an option for me.

Best regards,

Oksana

danilang

Hi @OksanaBezpyata

Look into using the field info tool, found on the developer palette

The column names show up in the name column of the result, with no caching between runs

Dan

FieldInfo.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703