Alteryx Designer Discussions

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

Dynamic Multi Field Value Replacement

mjh418
8 - Asteroid

Hi All !

 

I need help with dynamic multi-field situation. 

Situation is below:

 

1. The number of Fields which differ by number suffix(1,2,3..) is NOT FIXED. So sometimes, there can be just two fields, Type and Type2. But sometimes it can be Type ~ Type 10 with 10 columns. 

2. I need to build a dynamic formula which IF TYPE is blank, then use the Type2 OR WHATEVER COLUMN THAT HAS A VALUE.

At least the good thing is there will always BE JUST ONE column that has A VALUE.  There will not be two or more columns with values. IF one column has a value, then REST columns will ALWAYS be empty. Just that the number of columns are not fixed but changeable.

 

TypeType2Type3TypeXX....
11   
 22  
  33 
   46

 

Expected Outcome:

Type
11
22
33
46

 

Thank you so much for your time.

10 REPLIES 10
atcodedog05
21 - Polaris

Hi @mjh418 

 

Question 1: Yes thats correct. You can do that.

 

Question 2: You can use formula like below

 

REGEX_Replace([Name2], "(.+\u)[\d_]+", "$1")

 

 

Hope this helps : )

Labels