Selecting certain records while LOADing in QlikSense

[rvijayanth]

What is the syntax for restricting rows while loading data using Data Load editor.

For example I want to load "Color" column where the values are ONLY red and green

Load

Color as "System Color"

Quantity

From  "File"

where color in ('Red', 'Green')

How to do this?

[shraddha_g · Accepted solution]

Try:

Load

Color as "System Color"

Quantity

From  "File"

where wildmatch(Color,'Red','Green');

[rvijayanth]

Thank you so much