Common filter for multiple data set

[jjustingkm]

i have 3 data sets like below. I need to provide an indicator filter that will have values 'Y' and 'N' using the third data set.  When select 'Y' it select only sales and order for a and b, when select 'N' select value for c and d. 

Sales				Order			Indicator
Region	sales			Region	Order		region	IND
a	30			a	60		A	Y
b	30			b	50		B	Y
c	80			c	80
d	30			d	30

[Vegar]

Is it the different use of UPPER sn lower case letters in your key  data and field name that is the issue?

Try loading the indicator data like this:

LOAD lower(region) as Region, IND FROM  indicatorSource;