How to split the data?

KNIME Analytics Platform
1

Hey,

I have a tricky question:

USE CASE

Let’s say that we have two tables:

Company table (all companies)

Contacts table (all contacts for the companies)

We would like to make a workflow which takes all companies, so that it only selects maximum of 10 contacts per company (some companies could have over 50 contacts).

How to do that in Knime?

Thanks,

/JH

2

You could use a group loop start node (over the companies) and then in the loop apply a row sampling. You don't even need the "Company table".

3

Hey,

wiswedel - how would you create that kind of loop start node? 

Never used those before?

Thanks,

/JH

4

See attached workflow.

Cheers,

Jon

5

Thanks a lot - perfect!! :)