community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Lookup row value to match column range to find column within range and provide the value

Meteoroid

I'm trying to figure out how to lookup row value to match column name and provide the value for that respective column.

Can a formula do the trick?

 

Cost CC136110141463648590100037584544006882
648500020001037202500
101402502001003810780
003700025100395790
68820005010000580500

 Find from column Cost CC 6485 in column range 1361 - 6882 and return value (in this case it would be 2000).

This is just a sample. My actual file have thousands of rows and at least 40 columns (column name are numbers).

 

Any help would be appreciated!

Quasar

Sample workflow as below.  Hope this is helpful. 

 

Lookup row value to match column range to find column within range and provide the val - workflow.PNG

Meteoroid

Thank you Ponraj. Can you show me the configuration for the transpose?

Quasar

Hi @DeorajK !

 

Here is the configuration of the Transpose tool in @ponraj's solution - just in case you can't open the workflow he attached.

 

Capture.PNG

Meteoroid

Thank you very much!

Labels