community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Number sequence

How can I get the number sequence as attached? I have the column 'Type' using which I'm trying to derive column 'Number'.

 

Number sequence.PNG

 

I'm not sure if I can get this using Multirow or Tile, yet to try on these. Initial thoughts are heading towards writing a complicated formula but thought to check with the community if there is an easier solution? 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I took a route that used the Tile, Multiple Multi Row Formula, and transformation tools. I used a few more tools than necessary, but it should be easy to follow (browses at key points) and scale. 

 

20191213-TreeAssignment.png

 

 

 

 

 

 

 

 

 

 

 

 

Check out the attached example solution and let me know if this works for you.

Alteryx Certified Partner

Hi @cghanshyam ,

 

One way to achieve that is by creating an additional column only to create that kind of sorting.

Take a look at the attached example and let me know if that works for you.

 

fmvizcaino_0-1576254245758.png

 

Best,

Fernando Vizcaino

Hi there, 

 

I think this might be what you're looking for. I got there with with multi-row formulas, a transpose tool and summarize/concatenation. Let me know if you have any questions.

Greg_Murray_0-1576254049211.png

Charlie, thank you so much! There's always so much more to learn from you. Your solution too got me to the answer.  

Labels