topic Re: Help!! Incremental load and store data quarterwise in QlikView

Help!! Incremental load and store data quarterwise

mjayachandran — Wed, 01 Oct 2014 09:51:37 GMT

Hi,

Below is my requirement:

I have 3 Tables in my DB

// Contains the below fields. Create and modify operations happen on this table:

Master_Table:

Transaction_ID, Transaction_Date, Partner_Code, Partner_Name, SKU, DB_Create_Date, DB_Modified_Date;

// Customer defined Fiscal Calendar

Fiscal_Calendar:

Start_Date, End_Date, Fiscal_Month, Fiscal_Quarter, Fiscal_Year;

// Contains all the Purged Transaction from Master_Table

Purge_Table:

Transaction_ID, Transaction_Date, Partner_Code, Partner_Name, SKU, DB_Create_Date, DB_Modified_Date;

I'm trying to achieve the below:

Incremental Load that supports:

1. Should extract and store Data Quarter-wise, Like Master_Data_2014Q1.qvd, Master_Data_2014Q2.qvd;

2. If there is any new record Create or Record Update in any Quarter the incremental Load should handle the same and store it back to respective Quarter QVD.

3. Should check for new Records in Purge_Table and remove the same from Respective Quarter QVD.

Thanks for helping in advance.

Re: Help!! Incremental load and store data quarterwise

fkeuroglian — Wed, 01 Oct 2014 12:50:49 GMT

Hi, see the attached and the links

Hope helps

Fernando

Incremental Load in QlikView – Part1 | Learn QlikView

Incremental Load in QlikView – Part2 | Learn QlikView

Incremental reload and store into QVD file

Re: Help!! Incremental load and store data quarterwise

mjayachandran — Thu, 02 Oct 2014 03:45:01 GMT

Hi Fernando,

Thanks you for posting. All the scenarios explains Incremental load for storing and updating data on a single QVD file. I have already implemented that at my customer end. But for my business case I want to implement Incremental load on Quarterly split qvd files. Anywhere in my db, any record is updated/New record is inserted the script should the Incremental script should identify the transaction by 'DB_Modified_Date' and update the same in respective quarterly qvd.

Thank you.

Re: Help!! Incremental load and store data quarterwise

mjayachandran — Mon, 06 Oct 2014 09:14:52 GMT

Hi All, Can anyone please help me with my requirement ?

Thank you....

Re-initiating this post hoping someone can help me..

Re: Help!! Incremental load and store data quarterwise

mjayachandran — Wed, 15 Oct 2014 14:20:21 GMT

any help . Thank you

Re: Help!! Incremental load and store data quarterwise

mjayachandran — Mon, 03 Nov 2014 12:43:26 GMT

hi any help !!

Thank you