Adding serial number based on pattern

Dear Knimers ,

PLease help me with this :slight_smile:
My Input Table and expected output table is attached below,
image

How can i achieve this ?

1 Like

hi @Suhas,

I would use a Java Snippet — NodePit and configure it like this:

The empty date rows should be formatted as missing values (red ?).

Hope that helps, Tommy

5 Likes

rule engine + moving aggregation could work as well
bR

5 Likes

Thanks @tommy , This is quicker and simple.
I was also looking more of a no code help.

Can you please be more specific ?

use rule engine to check the date column. If not missing return 1. Then use the moving aggregation and do a running total (cumulative checkbox) to sum up your created column with the 1s.

2 Likes

Hello,

just used your approach @Daniel_Weikert and worked like a charm. Nice one :+1: For beginners this is not so easy and intuitive so I suggest to create example workflow and point to it in future :wink: In the meantime maybe this workflow example helps @Suhas:

Br,
Ivan

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.