Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
binu_acs
21 - Polaris

@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
Top Solution Authors