Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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' ;
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' ;
Perfect...
That was a fast and absolutely correct answer
Thanks.