
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to do resident or precedence data loading in Qlik Sense
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.

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
