Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transpose and populate the values within the range

masakazuenami
6 - Meteoroid

I have the source data illustrated below where each line item has a range of Low and High.  I need to create a record for each of the sequential numbers in between Low and High for the same line item and populate them into a table format in the Expected result illustrated below (and repeat until it reaches the last row).  How do I do this?   

 

I'm new to Alteryx.  Any help would be appreciated!

 

 

 

 

Example.png

2 REPLIES 2
AndrewS
11 - Bolide

Hi @masakazuenami , a Generate Row tool will get you this result, workflow attached. Let me know if this works.

 

Spoiler
TransposeandPopulate.PNG
masakazuenami
6 - Meteoroid

@AndrewS  Thank you! This works perfectly!
Labels