Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

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.

1 Reply
MVP & Luminary
MVP & Luminary

Re: How to do resident or precedence data loading in Qlik Sense

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.