In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Top Solution Authors