1 Reply Latest reply: Oct 22, 2015 9:34 PM by jagan mohan rao appala RSS

    How to do resident or precedence data loading in Qlik Sense

    Sylvia Vargas

      I have been doing basic Qlik Sense dashboards using a SQL Server database for awhile.

      Now I am using a Cassandra data source and don't have the capability of SQL Server views to transpose the data before loading data into Qlik Sense.

       

      Now I am trying to learn more about data loading to perform transformations in Qlik Sense using data loading script and have read about resident and precedence tables, but can't seem to get it to work in Qlik Sense.

       

      Any examples or references would be greatly appreciated.

        • Re: How to do resident or precedence data loading in Qlik Sense
          jagan mohan rao appala

          HI,

           

          Try like this

           

          Preceding Load:

           

          TableName:

          LOAD

          *,

          Year(DateField) AS Year,

          Month(DateField) AS Month;     --- --- Preceding Load

          SELECT

          *

          FROM TableName;   -----Your Cassandra data source  query

           

          Resident Load:

          Temp:

          SELECT

          *

          FROM TableName;   -----Your Cassandra data source  query


          TableName:

          LOAD

          *,

          Year(DateField) AS Year,

          Month(DateField) AS Month

          RESIDENT Temp;     --- --- Preceding Load

           

          DROP TABLE Temp;

           

           

          Hope this helps you.

           

          Regards,

          Jagan.