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
binu_acs
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