I want to filter my Date datasets by Holidays datasets with something like that :
a = load "Date_Test"; b = load "Holidays_Test"; b = foreach b generate 'Holidays' as 'Holidays'; a = filter a by 'Date' not in [toDate('Holidays', "dd/MM/yyyy")];
But I've got this error :
Unknown IDTOKEN: Holidays
I don't really know how to join both datasets to get this filter.