First Occurrence of Combination

Adam480925
Adam480925 ⚪️
in Card Building

I have date that includes (something like) the following

 

DateIDClientRegion
1/20/201711111AEU
1/20/201711112AUS
1/20/201711113BEU
1/21/201711114AEU
1/21/201711115BUS
1/21/201711116CUS

 

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!

Best Answer

  • Adam480925
    Adam480925 ⚪️
    Answer ✓

    Never Mind solved

     

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

This discussion has been closed.

Categories