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