Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Easiest to do with a preceding load:
Load * Where Records <10;
Load Client, Count(RecordID) as Records
From YourTable
Group By Client;
Easiest to do with a preceding load:
Load * Where Records <10;
Load Client, Count(RecordID) as Records
From YourTable
Group By Client;
That works, thanks a lot!