Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

DeorajK
7 - Meteor

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!

4 REPLIES 4
ponraj
13 - Pulsar

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

DeorajK
7 - Meteor

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

ddiesel
13 - Pulsar
13 - Pulsar

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

DeorajK
7 - Meteor

Thank you very much!

Labels