Alteryx Designer Desktop Discussions

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

REGX Match and Addition Formula

harinder1301
8 - Asteroid

Heelo everyone,

I would like to get assistance in writing a reg ex formula . When the match occurs , i want to pick the value from field  S and add it.

I have created a formula to count the comma separated values . But 

 

REGEX_CountMatches([A], ",") + 1 

 

But I want to add the values if the count is greater than 2.

Desired output is in Column B. Please see attached file.

 

Many Thanks

Harinder

 

 

1 REPLY 1
Christina_H
14 - Magnetar

You don't actually need RegEx for this, see attached workflow.

Christina_Hurrell_0-1636543945913.png

 

Labels