Is there a way i can use this logic to create a new field in the script?
Date(Min([service_contact_date],episode_key)) as Referral_Commenced_Date
I want to use the first service contact date of each epsiode as their referral commenced date..
Data:load [service_contact_date],episode_key,.....FROM Source ;
left join(Data)load episode_key,Date(Min([service_contact_date])) as Referral_Commenced_DateResident Datagroup by episode_key;