Give unique identifier to each column in Alteryx

[KrishnaChithrathil]

Can we put some unique identifiers for each column in alteryx?

like this?

My requirement is i need to loop through each columns, to check if a value is present in it or not. I'll be having a different column order each time.

What I'm thinking is, If we've unique identifiers for each column, we can take 1, check for a particular value. If not present, check in 2.

Is this possible?

[grazitti_sapna]

@KrishnaChithrathil, can you share this sample template without data?

As per my understanding, A is your header, and Name, City, and Code are sub-headers under header A? Am I interpreting it correctly?

The part I am still confused about is how the Country subheader in column F5 should come in column F3 what if the Country subheader comes under a different Header?

Thanks!

[KrishnaChithrathil]

@grazitti_sapna 

I'm sharing the excel with you. I've removed the values in the columns.

[grazitti_sapna]

@KrishnaChithrathil, will this help?

In case you have multiple headers.

Thanks!

[KrishnaChithrathil]

@grazitti_sapna 

Can you provide that workflow.? So that I can run it my machine and check what  you've done.

[grazitti_sapna]

@KrishnaChithrathil, attached is the workflow.

Thanks!

[ChrisTX]

Are the header rows static, where you can skip a specific number of rows in the Input Data tool?

Suggestion.... look at the issue in a different way.  Focus on how to separate the Excel file into Header, Detail, and Footer sections.  Then focus on getting the field names and data types correct in the Detail section.

Chris