Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to create table in script to get client id according to below condition but it showing me error while loading.
Client_IdData:
Load
campaign_id Where campaign_start_date < today() and campaign_start_date > (today()-7) Resident INVITATION;
Please help me in this regard.
thats ok but from where you are getting campaign_start_date. I cant see in beoth Tables
>>campaign_start_date is not in Invitation Table,its in CAMPAIGNMETRICS Table.
Not in the script you posted...
Hi,
date(floor(campaign_start_date),'MM-DD-YYYY') as campaign_start_date,
campaign_start_date will be in CAMPAIGNMETRICS Table. Sorry i missed adding over there.
Thanks
Hi,
date(floor(campaign_start_date),'MM-DD-YYYY') as campaign_start_date,
campaign_start_date will be in CAMPAIGNMETRICS Table. Sorry i missed adding over there.
Thanks
Hi,
date(floor(campaign_start_date),'MM-DD-YYYY') as campaign_start_date,
campaign_start_date will be in CAMPAIGNMETRICS Table. Sorry i missed adding over there.
Thanks
I thing you could
Invitation
left join
CAMPAIGNMETRICS
based on batch_meta_data_id i.e make sure no other id common
then
Client_IdData:
Load
campaign_id
Resident INVITATION Where (campaign_start_date < today() and campaign_start_date > (today()-7) );