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.
Type | Type2 | Type3 | TypeXX.... |
11 | |||
22 | |||
33 | |||
46 |
Expected Outcome:
Type |
11 |
22 |
33 |
46 |
Thank you so much for your time.
Solved! Go to Solution.
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 : )