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
Here ,Reporting office:112,120
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
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.