topic Re: Incremental load with no date timestamp column in QlikView

Incremental load with no date timestamp column

Anonymous — Tue, 21 Oct 2014 06:38:29 GMT

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.

Re: Incremental load with no date timestamp column

tresB — Tue, 21 Oct 2014 07:24:20 GMT

Re: Incremental Load with out Time stamp

Incremental Load without date feild

Re: Incremental load with no date timestamp column

Anonymous — Tue, 21 Oct 2014 08:07:28 GMT

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

Re: Incremental load with no date timestamp column

tresB — Tue, 21 Oct 2014 08:23:39 GMT

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.

Re: Incremental load with no date timestamp column

Anonymous — Tue, 21 Oct 2014 09:46:19 GMT

Thank a ton tresesco will work on that