Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table with ClientID and ContactDate
I am trying to find all of the ClientIDs that have more than one contact on the same date
Is this possible?
Thank you
if i understood correctly, one solution in the load script :
Data:
LOAD * INLINE [
ClientID , contact, ContactDate
1, c1, 01/01/2020
1, c2, 01/01/2020
3, c3, 01/01/2020
];
Group:
load ClientID,ContactDate,CountContact where CountContact>1;
load ClientID,ContactDate,count(contact) as CountContact resident Data group by ClientID,ContactDate;
drop table Data;
the output : the ClientIDs that have more than one contact on the same date
Thank you - that output is exactly what I am after
I loaded the script and created a table but the CountContact field is only showing '-'
can you share the script ?