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

Help with conditional formula / extraction

AjaySetty
8 - Asteroid

Hello Masters,

 

I have the below data set example where C is the resulting output I need, out of the A & B column i want to select data which has values into C.

Please help.

 

ABC
R2015-100702015-10070
2013-10049D2013-10049
A2018-002612018-00261
2018-00113F2018-00113
2019-00118J2019-00118
A2012-100142012-10014
10 REPLIES 10
atcodedog05
22 - Nova
22 - Nova

Ok i understand now when Min() used on only numbers then finds min considering the whole number.

But if it used on chars then it works like a sort order and return first occurring

 

This is amazing 😎 who knew Min() was built for chars too. I had thought it would give a datatype error😅

 

Thanks for the explanation and this new learning @MarqueeCrew 🙂

Labels