Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

How can I align all rows to specific columns?

AKPWZ
8 - Asteroid

AKPWZ_0-1657176161299.png

When I'm grouping it based on numbers mentioned in the JSON_Name my workflow only able to group till 3 and than its not happening when numbers again start from 0. Can you please help me to how I resolve this in a better way? Thanks!

 

8 REPLIES 8
binuacs
21 - Polaris

@AKPWZ Can you provide the input data in an excel file?

AKPWZ
8 - Asteroid

Here is the data in an excel file

 

FilipR
11 - Bolide

Use the Multi-Row Formula. Please see attached.

FilipR_1-1657177695333.png

 

FilipR_0-1657177646316.png

 

grazitti_sapna
17 - Castor

Hi @AKPWZ, give this a try.

grazitti_sapna_0-1657178359363.png

 

Thanks!

Sapna Gupta
AKPWZ
8 - Asteroid

Hi @FilipR FlipR thank you for your reply: 

 

I used the logic you shared with me but I'm getting this error: 

AKPWZ_0-1657179287070.png

 

FilipR
11 - Bolide

@AKPWZ You missed two ")". Please see attached.

 

FilipR_0-1657179569232.png

 

AKPWZ
8 - Asteroid

@FilipR My bad, yes I missed two ")". 
Its working now. Thank you so much :)

FilipR
11 - Bolide

@AKPWZ glad I could help. Please mark my post as a solution. :)

Labels
Top Solution Authors