2 Replies Latest reply: Jun 23, 2017 5:57 AM by Daniel Sørensen RSS

    How to filter data in Data load edit

    Daniel Sørensen

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