looping over values of 2 columns

pipo.xlsx (8.7 KB)
I want to create a loop over unique values of FPC and LCS name in the given file and then select a plant based on the date. How can I accomplish this using knime?

Wich plant do you want based on the date ?
How do you select the plant ?
For FPC 1000502 there is the same date and 2 different Plant

I’m a little unsure what you’re trying to do, based on your description, but perhaps you don’t need a loop at all? Have you tried just using the GroupBy node to aggregate by FPC, LCS, and date (and/or plant)?