Create loop counter for each group (start with specific row)

Hello everyone,
I hope you are well.
I have a daily electronic questionnaire that stores the answers only without questions. Suppose the first answer is (ok). How can I add a column containing a counter of questions starting with 1 for the (ok) response and the end with 6 if the person completes the questionnaire (it is not necessary to be 6 because some people did not complete the questionnaire).
I’ll attach an example of the input and the output.

Thank you.
The input:
Book1_eg.xlsx (9.8 KB)
the output:
output_eg.xlsx (10.6 KB)

Hi @Suad_Alshammari

Welcome to KNIME Forum. See this wf create_loop_counter.knwf (47.0 KB)


gr. Hans

8 Likes

Thank you very much!!
That was great!!

2 Likes

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