topic Re: Randomly select value from a single cell with comma in Alteryx Designer Desktop Discussions

Randomly select value from a single cell with comma

jayross0117 — Fri, 23 Aug 2019 03:29:50 GMT

May I know how can I randomly select one value from a single cell with comma separator?

Input Value

Expected Output

I appreciate your help on this.

Thanks!

Re: Randomly select value from a single cell with comma

benakesh — Fri, 23 Aug 2019 12:42:04 GMT

Hi @jayross0117 ,

randint() can generate 0 to n random nums .

I changed random formula to : RandInt([Max_Tile_SequenceNum] -1 ) +1

Re: Randomly select value from a single cell with comma

jayross0117 — Fri, 23 Aug 2019 10:16:46 GMT

Thanks @benakesh. That's a cool solution. I tried it and it worked. However, I just have a quick question. My cell values can have a different number of rows after using text to columns. A single cell can have a 3 rows, the another cell can have 2 rows. How can I run the workflow dynamically when they have different no. of rows also? Thanks!

Re: Randomly select value from a single cell with comma

benakesh — Sat, 24 Aug 2019 01:59:49 GMT

Hi @jayross0117 ,

I revised original post and replaced attached workflow .

Re: Randomly select value from a single cell with comma

jayross0117 — Fri, 30 Aug 2019 10:12:42 GMT

Thank you so much @benakesh!!! That works!