Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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