Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mastankomatla21
Contributor III
Contributor III

Incremental load by using primary key

Hi Team,

Good Morning!!

Could you please let us know,how can we implement incremental load without having Date field .If we can implement by using Primary key kindly show us the example script.

By using primary key can we implement following three methods in incremental load.

1.Insert

2.Insert and update

3.insert, update and delete

Regards,

Masthan

 

 

11 Replies
Mauritz_SA
Partner
Partner

Hi Masthan

That is very strange. Are you sure that you have the correct spelling of the column name and that you are loading it from your source again (and not a table in memory)? Below is a piece of a similar script (with variables instead of names) which is used in production. In your case the vJoinColumn would be Id.

INNER JOIN ($(pTable))
                    SQL
                    SELECT
                    $(vJoinColumn)
                    FROM
                    [$(pDataBase)].[dbo].[$(pTable)]
                    ;
 
Regards,
Mauritz
Anuhyak1
Contributor III
Contributor III

Hi Mastan,

Can you share the qvw file of Incremental logic that you have implemented with all the three steps.

Thanks