Create number ranges

[tanvir_khan]

Hi all,

I've range of numbers like below in my dataset:

Input

4543443591||4543443591

6655427400||6655427410

7444748637||7444748638

And I need to create sequences as below from above dataset. Can anyone help me to build the logic in Alteryx? Thanks in advance.

Output
4543443591
6655427400
6655427401
6655427402
6655427403
6655427404
6655427405
6655427406
6655427407
6655427408
6655427409
6655427410
7444748637
7444748638

Thanks

[Qiu · Accepted solution]

@tanvir_khan 
You can try with the Text to Column and Generate Rows tools.

[Dhrish · Accepted solution]

@tanvir_khan you can utilize the generate rows tool and regex tool. Refer the attached workflow.

[Pilsner · Accepted solution]

Hello @tanvir_khan 

There are several ways you could do this, but I agree with Qui and Dhrish that the easiest is probably with the Text to columns and generate rows.

The main trick is to use generate rows to:
1) Start at the number on the left of the |
2) Loop through, adding one each time
3) Stop when it reaches the number on the right of the |

I have attached my workflow below. Please let me know if you want me to explain anything further.

Regards - Pilsner

[tanvir_khan]

Thank you all!