Give unique identifier to each column in Alteryx

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?

Datasets

Gallery

Developer Tools

Error Message

Output

Custom Tools

Connectors

Common Use Cases

Bug

Accepted answers

All comments

grazitti_sapna

Hi @KrishnaChithrathil, if you are just looking to find values from the nth columns, why don't you try transposing then filter that would give you results faster. Please take a look at the screenshot.

Thanks!

grazitti_sapna

@KrishnaChithrathil, if you are looking for the exact expected output then give this a try.

Thanks!

KrishnaChithrathil_workflow.yxmd

KrishnaChithrathil

@grazitti_sapna

I understood what you meant.

Suppose, I want to identify where column-2 is. and need to perform some action to that column alone. The thing is column-2 can appear as the first column or the last column. It's not fixed. Can we do that?

ArtApa

Hi @KrishnaChithrathil - I think I don't fully understand the problem. Column names in Alteryx are unique identifiers themselves. You can't have duplicate column names. Also, it does not matter what is the order of the columns.

If you want to search for a specific value in different columns a Multi Field Formula tools can do that for you: https://help.alteryx.com/current/MultiFieldFormula.htm

KrishnaChithrathil

Hello @ArtApa

Suppose I want to take the Column-3 from this table and make all the Values to uppercase. But I don't know the position of this column-3.

I can't always assume this will be in third column.

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

Give unique identifier to each column in Alteryx.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703