multiple row fomula question

Question

Hi Alteryx engineer,

I have some data like this

ABC123TOTALD123TOTALEFG

I Want to concatenate string under C and D section and  output like below, how can i implement?

ABCC1C2C3TOTALDD1D2D3TOTALEFG

Yoshiro_Fujimori · Answer

Hi @187 ,

It depends on the condition to distinguish the Level-2 string (1, 2, 3...) from the Level-1 string (A, B, C...).

Currently, the strings are distinguished whether it is all numbers or not (in Multi-Row formula and Formula) as below:

REGEX_Match([Data], "\d+")

If there is a different rule, you can modify the regular expression accordingly.

187 · Answer

Hi @Yoshiro_Fujimori

Thanks for the reply, yes this is working for the case, just wondering if the 1 2 3 is not number , and it is string as well, what is the advice?

Yoshiro_Fujimori · Answer

Hi @187 ,

Here is one way of doing this.

Workflow

Multi-Row formula expression

Output =

IF RegEx_Match([Data], "\d+")
THEN [Row-1:Output]
ELSE [Data]
ENDIF

Formula tool expression

Output =

IF REGEX_Match([Data], "\d+")
THEN [Output] + [Data]
ELSE [Output]
ENDIF

Output

MultiRow2.yxmd