Creating dynamic serial number

Hi all,

Please help with the attached query. In the file, there are input and the desired output sheets.

Thanks,

SP

Alteryx query 3.xlsx

Datasets

Accepted answers

You can do this by following the logic of the below workflow

1. using record ID to generate IDs

2. splitting values into rows using newline as delimiter

3. using mutirow formula to generate sub ID

4. using formula to generate serial number.

Hope this helps 🙂

serial number.yxmd

All comments

You can do this by following the logic of the below workflow

1. using record ID to generate IDs

2. splitting values into rows using newline as delimiter

3. using mutirow formula to generate sub ID

4. using formula to generate serial number.

Hope this helps 🙂

serial number.yxmd

Hi,

Thank you so much for your help. It works perfectly.

I have another problem for which i couldn't find a solution. Can you please help? I really appreciate a lot!

Alteryx query 1.xlsx

Hi,

Could you please explain what the multirow formula does?

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703