How to do resident or precedence data loading in Qlik Sense

[#1]

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.

[jagan]

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.