Create number ranges

Question

Hi all,

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

Input4543443591||45434435916655427400||66554274107444748637||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.

Output45434435916655427400665542740166554274026655427403665542740466554274056655427406665542740766554274086655427409665542741074447486377444748638

Thanks

Qiu · Accepted Answer

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

Dhrish · Accepted Answer

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

Pilsner · Accepted Answer

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