Replicating records based on content value in string

[AmrithKandlur]

Hi All,

In addition to that, I have a challenge with the following scenario.

Name,age,Range

John,28,TJY00783 HULB002-TJY00783 HULB004

Mark,32,Sydney,TJY00456 HULB002-TJY00456 HULB006

I want the data to be like the below

Name,age,Range

John,28,TJY00783 HULB002

John,28,TJY00783 HULB003

John,28,TJY00783 HULB004

Mark,32,Sydney,TJY00456 HULB002

Mark,32,Sydney,TJY00456 HULB003

Mark,32,Sydney,TJY00456 HULB004

Mark,32,Sydney,TJY00456 HULB005

Mark,32,Sydney,TJY00456 HULB006

Alteryx should recognize that there is a "-" in the range text, then consider using the last three characters of the text before the - and last three characters after the - and split the records as above.

[flying008]

Hi, @AmrithKandlur 

Just like this  as your want?

[AmrithKandlur]

Yes Please, Could you please share this workflow?

[grazitti_sapna]

@AmrithKandlur, give this a try.

I hope this works!

Thanks!

[AmrithKandlur]

Yes Please, Could you please share this workflow?

[AmrithKandlur]

ok, I got the workflow downloaded