"Error in expression: ')' expected" while loading script

[berryandcherry6]

Hi all,

I am trying to load below expression ,getting error saying "Error in expression: ')' expected" but i have made sure every thing is fine,whats making me get this error.

CurrentCampaignData:

Load

batch_meta_data_id,

campaignid as current_campaign_id

Resident CAMPAIGN Where ((current_start_date = Date(weekstart(Num(today()))+1)) and batch_meta_data_id = (23,24,25));

Please help me in this regard.

Thanks,

Supriya

[berryandcherry6]

Hi,

no, not where condition

current_campaign_id  column values , where  i  get  from  CurrentCampaignData table.That column value i have to pass to set analysis.

[Kushal_Chawda]

Just Open the New thread with detail of your requirement, giving example with sample data so that it will be easy to understand the requirement