First Occurrence of Combination

Adam480925

I have date that includes (something like) the following

 

Date	ID	Client	Region
1/20/2017	11111	A	EU
1/20/2017	11112	A	US
1/20/2017	11113	B	EU
1/21/2017	11114	A	EU
1/21/2017	11115	B	US
1/21/2017	11116	C	US

 

I am looking for assistance on a beast mode (or ETL Data Flow) that will pull me the name of client + Region combination that we first received Inquiries from on a certain day - so in the table above, on Jan 21 we received our 1st inquiries from client B in the US and Client C in the US

 

Thanks in advance for any hints that might point me in the right direction!

Adam480925

Never Mind solved

 

ETL -> Group by Client, Region With Minimum Date gives me a first inquiry result

Adam480925

Never Mind solved

 

ETL -> Group by Client, Region With Minimum Date gives me a first inquiry result