Filter in Load Script

[jan2]

Hi,

my data contains rows which I don't need. So I want to filter them in the load script so that they are not loaded.

Simple example: I have the column location which contains: London, New York, LA, Berlin. But I only want to load the data for London and Berlin. Which command do I have to use?

Thanks in advance. 

[Frank_Hartmann]

maybe like this:

Load * Inline [
location
London
NewYork
LA
Berlin] 
Where  match(location, 'London','Berlin');