Get header position information

Question

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

Emmanuel_G · Answer

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 ?

Get order of columns.yxmd

binu_acs · Answer

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

Heading_position_12+-7.yxmd