Dear Knimers ,
PLease help me with this 
My Input Table and expected output table is attached below,
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 
For beginners this is not so easy and intuitive so I suggest to create example workflow and point to it in future 
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.