Discussion Board for collaboration on QlikView Scripting.
These scernoirs what you send is very basic would you post somthing like sql database having multiple tables some tables are concatenated and other are remain I dont have timestamp rather that have Date.My Question is How To do update and insert for these scenarios?
Let consider these scenorios
//For Concatenated tables
Load * From Datasource;
Load *From Datasource;
Load From Datasource;
Load * Datasource;
I dont understand why you concatenate 3 times the same table as TabA. Why you are doing this? As Dathu says can you post the rules you can use to identify the rows to add or update? What is the key of this table?
You can use date column in source table to update or insert records.
Try to use Exist() - to update when records exist in QVD or Resident Load and source table date is greater than date in QVD for particular record.
Next use Not Exist() to insert records which do not exist in QVD or Resident Load.
You can use primary key,if you don't have date field to insert records which do not exist in already loaded data.
Please check below script:
TEMP:LOAD MAX(pid) AS MAXPID
DROP Table MASTER;
LET Vmax = Peek('MAXPID',-1,'TEMP');