Top row average against unique id

Hello Everyone!

Trust you are doing well. I need help on the following query -

I have the below (screenshot) data set, and need the average of top 4 dues against each id i.e. the output would be
ID Average Due
a 15
b 66.75
c 49.5

Thanks!
Omprakash

image

Hi @Omprakash_Jena

See this wf: KNIME_project.knwf (28.2 KB)
image
gr. Hans

4 Likes

Thanks @HansS ! It worked.

2 Likes

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