Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

varmekontrol
New Contributor II

How to filter data in Data load edit

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);


  

1 Solution

Accepted Solutions
kvanandan1
Contributor

Re: How to filter data in Data load edit

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' ;

2 Replies
kvanandan1
Contributor

Re: How to filter data in Data load edit

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
New Contributor II

Re: How to filter data in Data load edit

Perfect...

That was a fast and absolutely correct answer

Thanks.