Hello Everyone,
I have a very baisc question but it seems not to work by me.
I have a feature with 2 fields with postcode data:
AGS_Schule = the postcode where the school is located (STRING)
AGS_herkunft = the postcode of origin of the students that attend this school (STRING)
I want to filter the featureset in order to have ONLY those students Postcodes which are different form the Postcode of origin.
In fact the exact contrary of this:
The indicator can read this conditon and brings the data where the 2 AGS Postcodes are identical:
But when I write var fs_filt = Filter(fs, 'AGS_Schule != AGS_Herkunft') I do not get a usable FeatureSet, or at least it seems to be empty. And I am sure there are 200 records that meet this condition.
The indicator cannot read this expression:
What am I missing? I also tried to return the output as:
return Featureset(Text(fs_filt))
But didn´t work at all.
Thank you in advance for your help!
Solved! Go to Solution.
Filter() uses a SQL expression. In SQL, the test for unequal is "<>".
var fs_filt = Filter(fs, 'AGS_Schule <> AGS_Herkunft')
Filter() uses a SQL expression. In SQL, the test for unequal is "<>".
var fs_filt = Filter(fs, 'AGS_Schule <> AGS_Herkunft')
Hello Johannes.....
well, thank you! It worked!
I clearly missed that lesson!