Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As jontydkpi mentioned, make correction in your syntax
Resident CAMPAIGN
WHERE (current_start_date = Date(weekstart(Num(today()))+1)) and match(batch_meta_data_id ,'23','24','25');
Hi,
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));
Hi,
thanks for your reply
But having same issue
try
Resident CAMPAIGN Where ((current_start_date = Date(weekstart(Num(today()+1))) and batch_meta_data_id = (23,24,25));
Hi,
Showing same error.
This is invalid syntax:
batch_meta_data_id = (23,24,25)
The where clause should probably be:
Where current_start_date = Date(weekstart(Num(today()+1)))
and Match(batch_meta_data_id, 23,24,25);
As batch_meta_data_id is a integer and not a string , 'in' clause or structure will lead to an error.
use:
Resident CAMPAIGN Where ((current_start_date = Date(weekstart(Num(today()))+1)) and MATCH(batch_meta_data_id, 23, 24,25));
As jontydkpi mentioned, make correction in your syntax
Resident CAMPAIGN
WHERE (current_start_date = Date(weekstart(Num(today()))+1)) and match(batch_meta_data_id ,'23','24','25');
Hi kushal chawda,
Thanks it worked,
Can i pass this obtained values from this table to set analysis,to evaluate ?
yeah, You can pass these values to set analysis if you don't want to use in WHERE clause