Load only records where a certain value is used a certain amount of times

[NicholasIQ]

Hello all,

I have a question. I have a table with columns 'upn',  'sct', 'specialism'. The 'upn' column contains client numbers. I want to load two versions of this table.

1. The full table. This presents no issues.

2. The table, but only the subset of records of clients with a maximum of 10 records. For example, if a client has 11 records in the table, I don't want to load those records. If a client has anywhere between 1 and 10 records, I want to load those records. 

I want to do this in the data load editor. 

Thanks a lot for helping out!

NicholasIQ

[Or · Accepted solution]

Easiest to do with a preceding load:

Load * Where Records <10;

Load Client, Count(RecordID) as Records

From YourTable

Group By Client;

[NicholasIQ]

That works, thanks a lot!