How to filter data in Data load edit

[varmekontrol]

Hi all friendly Qlik users

I am pretty new to this Qlik universe, and in general the Java, HTML language, so maybe this will be an easy one to help me with.

I am loading 6 CSV. files that I would like to filter in, especially the " orgUnit" where there are 3 different names, but I am only interested in one of them for my app.

I know there is something called a " Where clause" but am unable to find any help about my specific load.

In this load, I would like to filter in the "orgUnit" and only load the name " AALB " into my app from that "orgUnit"

LOAD

    orgUnit,

    propertyNumber,

    baseArticleNumber,

    serialNumber,

    consumptionUnitNumber,

    neverReached,

    thirtyDayReached,

    referenceDate   

FROM [lib://DeviceList/DeviceList.txt]

(txt, unicode, embedded labels, delimiter is ';', msq);

LOAD

    orgUnit,

    propertyNumber,

    baseArticleNumber,

    serialNumber,

    consumptionUnitNumber,

    errorState,

    criticalError,

    errorDate

FROM [lib://ErrorList/ErrorList.txt]

(txt, unicode, embedded labels, delimiter is ';', msq);

[kvanandan1 · Accepted solution]

Hi,

Please use the where condition after the from clause. as mentioned below

LOAD

    orgUnit,

    propertyNumber,

    baseArticleNumber,

    serialNumber,

    consumptionUnitNumber,

    neverReached,

    thirtyDayReached,

    referenceDate  

FROM [lib://DeviceList/DeviceList.txt]

(txt, unicode, embedded labels, delimiter is ';', msq)

Where orgUnit = 'AALB' ;

[varmekontrol]

Perfect...

That was a fast and absolutely correct answer

Thanks.