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

[AKPWZ]

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

[ShankerV]

Hi @AKPWZ 

One way of doing this easily is.

Many thanks

Shanker V

[ShankerV]

Hi @AKPWZ 

Using multi row formula.

IF Right([Field1],1)="0"
THEN [Row-1:Output]+1
ELSE [Row-1:Output]
ENDIF

Many thanks

Shanker V

[RobertOdera · Accepted solution]

Hi, @AKPWZ 

Your sample data suggests a pattern that requires solving for an increase of records from 1, 10, 100, 1000,...Nth.

But maybe your data will never go/grow to that extent (anyways, I still took care of that possibility).

Please see the below.

Please mark it as an acceptable solution if it works for you. Cheers!

[RobertOdera · Accepted solution]

Hi, @AKPWZ 

This solution anticipates the future.

Please see the below.

Please mark it as an acceptable solution if it works for you.

[AKPWZ]

Thank you @RobertOdera this is exactly what I was looking for.

[AKPWZ]

Thank you @ShankerV for your response. Your given logic is not working for me, as it touch 10,11,12 and so on; its giving only the first integer value as an output  like, for 10 - 1, 11 - 1, 12 - 1 , its not giving me as 10, 11, 12, ...

[ShankerV]

Hi @AKPWZ 

Thanks, I just tweaked the below to get your result done.

From (\d) to (\d+)

Many thanks

Shanker V

[AKPWZ]

Hi @ShankerV, @RobertOdera attached that sample as a screenshot, please have a look at it.

[ShankerV · Accepted solution]

Hi @AKPWZ 

Have posted the modified workflow in the last post, please check whether it helps!!!!

I have checked with many inputs, works fine. Can you check and confirm from your end!!! Fine, if it works as expected.

Cheers!!!!

Shanker V