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

Convert string to table

Nastya
8 - Asteroid

Hello everyone!

I need to create a table, which shows how many times the value was in the string 

Example is the following:

Input

Route
388-3256-388

Output

RoutePointTimes 
388-3256-3883882
388-3256-38832561

 

Thanks a lot for any help!

2 REPLIES 2
jasperlch
12 - Quasar

Hi @Nastya

 

This can be do by using a REGEX_CountMatches() function in a Formula tool:

 

Capture1.PNG

DavidP
17 - Castor
17 - Castor

How about this?

Labels
Top Solution Authors