getting error "garbage after statement" while loading script

[berryandcherry6]

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.

[SunilChauhan]

thats ok but from where you are getting campaign_start_date. I cant see in beoth Tables

[jonathandienst]

>>campaign_start_date  is not in Invitation Table,its in CAMPAIGNMETRICS Table.

Not in the script you posted...

[berryandcherry6]

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

[berryandcherry6]

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

[berryandcherry6]

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

[SunilChauhan]

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) );