Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I was trying to implement incremental load, I'm not sure how to implelement when the coloumn names in the table of qvw file is different(bcos they have been renamed) from the new file that has new records.
I did try various solutions , but some how success eludes me,I have been banging my head since 3days trying to figure it out.I was hoping if some could help me , By implementing incremental load for the attached file.
I took a look into the excellent incremental load example within the QV cookbook, available from Rob Wunderlichs site: http://robwunderlich.com/downloads/ ( Being new to Qlikview I found it a little complex to understand)
I have attached a sample qvw, with a table box(name of the table box is Target), the columns have been renamed in the qvw file, Now i want to do incremental load by providing another file with new data (I'm attaching a sample excel file,file name is sample2.qvd which i want to integrate with the qvw). In such a way that whenever i provide a file with new recordss qv must integrate them successfully.
I would really appreciate it if someone implements the solution in the file i have attached.
Can somebody attach an example, with a new source file containing new records ?
Thanks
Swarup
Hi Swarup,
I wasnt able to simulate with sample2.qvd but with excel sheet it worked. Try as below:
ATT_MONTHLY_VOICE:
Load * from sample1.qvd(qvd);
Concatenate
Load A as FAN,
B as FANNAME,
C as BAN,
D as BANNAME,
E as PHONENO,
F as BILLDT,
G as PK_KEY,
H as DATE_1,
I as Time,
J as NUMBER_DEST,
K as CALLEDCITY_DEST,
L as MTSUSED,
M as RATEPD,
N as Feature,
O as ATCHRG,
P as ADDCHRG,
Q as INTTAX,
R as ROAM,
S as Total,
T as M2MMTS,
U as VMMTS,
V as CWMTS
FROM NewExcelDocument.xlsx
(ooxml, explicit labels, header is 3 lines, table is Sheet1);
Store ATT_MONTHLY_VOICE into sample1.qvd;
PS: The excel load should be explicit and give the header size so that you will start from data rows.
Regards,
Kiran.
Hi Swarup,
I wasnt able to simulate with sample2.qvd but with excel sheet it worked. Try as below:
ATT_MONTHLY_VOICE:
Load * from sample1.qvd(qvd);
Concatenate
Load A as FAN,
B as FANNAME,
C as BAN,
D as BANNAME,
E as PHONENO,
F as BILLDT,
G as PK_KEY,
H as DATE_1,
I as Time,
J as NUMBER_DEST,
K as CALLEDCITY_DEST,
L as MTSUSED,
M as RATEPD,
N as Feature,
O as ATCHRG,
P as ADDCHRG,
Q as INTTAX,
R as ROAM,
S as Total,
T as M2MMTS,
U as VMMTS,
V as CWMTS
FROM NewExcelDocument.xlsx
(ooxml, explicit labels, header is 3 lines, table is Sheet1);
Store ATT_MONTHLY_VOICE into sample1.qvd;
PS: The excel load should be explicit and give the header size so that you will start from data rows.
Regards,
Kiran.
Hi Kiran,
Thank you for your your help, let me try it
Regards
Swarup