Start Free Trial

Alteryx Designer Desktop Discussions

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

How to use Multi-Row formula to get the desired output

AKPWZ
8 - Asteroid

I'm trying "If StartsWith(JSON_Name,'data.rows.0') Then [Row-1:Counter]+1 Else[Row-1:Counter] EndIf"  into Mmulti-Row formula tool to get the desired output (attached screenshot), but not sure what I'm doing wrong and getting something else.

 

I want to use a counter whenever there is a change - like;  'data.rows.0' to 'data.rows.1' and likewise

Please review my logic and help me to get the right solutions. Thanks

 

AKPWZ_1-1676288815883.png

 

12 REPLIES 12
RobertOdera
13 - Pulsar

Sure thing, @AKPWZ .

Happy to help.

Please mark it as an acceptable solution - cheers!

RobertOdera
13 - Pulsar

Actually, @AKPWZ 

 

@ShankerV updated solution will now also work for you - kindly credit @ShankerV  for the solution given first responder to your question. Or mark both as solutions if that is possible 😎

AKPWZ
8 - Asteroid

Thank you @ShankerV Its working for me. :)

Labels
Top Solution Authors