Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Find a column from value in other column

Highlighted
6 - Meteoroid

I want to call specific columns based on another column inside formula tool.

Attached workflow is my attempt and shows I want to do (it doesn't run properly)

 

I have an input table and desired output table below.

 

Input

 

MaxCP1CP2CP3Time1Time2Time3
3123201901201903201910
2264201703201704201705
1322201701201801201901
351011201801201807201901

 

Output

MaxCP1CP2CP3Time1Time2Time3Max CPMax Time
31232019012019032019103201910
22642017032017042017056201704
13222017012018012019013201701
35101120180120180720190111201901

 

Thank you so much for your help!

 

 

Highlighted
Alteryx Certified Partner

Hey @sakimur1 

 

I would do someting like this:

 

Capture.PNG

6 - Meteoroid

Hi @LordNeilLord,

 

Thank you so much for your response. For Max Time Column, I want to show the time when CP was at max.

So for row 2, Max CP is CP2, so I want Max Time to be Time 2 which is 201704.

 

Thank you so much for your help!

Labels