Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
Thank a ton tresesco will work on that