Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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