Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Get header position information

KrishnaChithrathil
11 - Bolide

Hello community!

 

Is there any way we can get the position of headers? I tried with field info tool. 

yes, I'm getting all the header related information. But the thing is, I can't expect, say Column-1, will always be first. Sometimes, the requirement may change the Column-1 as the last column. So the code should be flexible enough not to break rest of the flow.

 

Please consider an excel having 50 columns. The position of column may change. 

 

 

 

Regards,

Krishna

2 REPLIES 2
binuacs
20 - Arcturus

@KrishnaChithrathil may be you can transpose the header and add a recordID tool like below

binuacs_0-1657640526837.png

 

Emmanuel_G
13 - Pulsar

Hi @KrishnaChithrathil ,

 

The field information tool normally keeps the orders of input fields. 

 

Find a test attached. I made two tests in different containers.

 

You want something like this ?

Emmanuel_G_0-1657651977597.png

 

 

Labels