Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
swethasmilek
New Contributor III

Incremental load with no date timestamp column

Hi friends after successful completion of scripting to one country stuck with incremental load scalability.Issue facing scenario is to perform incremental load no date or time stamp,to do incremental load

We get data to shared server in data folder from each country we get 6.text files in loading each country has Accounting period & Reporting office

Naming convention of files are

112_Jamaica_05-01-2014_retailsale. txt

112_Jamaica_05-02-2014_retailsale. txt

120_Ind_05-01-2014_grosssale. txt

120_Ind_06-01-2014_gross sale.txt

Here ,Reporting office:112,120

Accounting period:mm-dd-yyyy(05-01-2014)

Condition 1:For same Accounting period and reporting office records are to be replaced

Condition 2: For different Accounting period and reporting office concatenate to previous month

Please do needful help on issue actually this is my first project on QlikView.

4 Replies
MVP
MVP

Re: Incremental load with no date timestamp column

swethasmilek
New Contributor III

Re: Incremental load with no date timestamp column

Suppose For same A/c period & Reporting Office: Records are Replaced

For Different  A/c period & Reporting Office: Concatenate to previous month

Have Primary key:Policy Number in our case there is no need of Insert,update and delete

Please give right solution to work on

MVP
MVP

Re: Incremental load with no date timestamp column

So it's not really a typical incremental load scenario(to be honest I only read your caption of the post earlier ). Here, you can fetch the filename using FilaBaseName() and store it in a variable, then check the various section like reporting office, accounting period ... probably using  subfield( vFielName, '_', 1/2/3..). Once the information is with you in diffrent variables, you can conditionally decide if the load is to be concatenated or overwritten.

swethasmilek
New Contributor III

Re: Incremental load with no date timestamp column

Thank a ton tresesco will work on that