Replace or Update

[#1]

I have a excel file which have many columns

I load this excel file into qlikview.

also I have another excel file which contains the updated data(only one column values are updated but not all values only few)

how to update the data in the qlikview.

[lmonincx]

Hi have a look at the QV reference manual ( programfiles/qlikview/documentation) book 1 part 4 chapter 24 using QVD for incremental load, ( or type incremental in the search box) , there are different ways listed on how to handle changes in your source data.

Regards,

Linda

[#3]

Test data goes here

I have this data

Date Name Value
1-Nov A 1
2-Nov B 1
3-Nov C 1
4-Nov D 1
5-Nov E 1
6-Nov F 1
7-Nov G 1
8-Nov K 1
9-Nov L 1
10-Nov M 1

in another excel I have

Date	Name	Value
1-Nov	A	1
3-Nov	C	3
4-Nov	D	4
6-Nov	F	6
7-Nov	G	7
9-Nov	L	9

Now I need to update the data of each data

so fina data would be

Date Name Value
1-Nov A 1
2-Nov B 1
3-Nov C 3
4-Nov D 4
5-Nov E 1
6-Nov F 6
7-Nov G 7
8-Nov K 1
9-Nov L 9
10-Nov M 1

[#4 · Accepted solution]

Any updates can any bdy help me

[lmonincx]

Hi Please see attached, it's using an applymap to add the new file, then in creating the final fact table it's looking first for the new values and if no new values are there it's using the original values.

You need to store the final fact as a qvd and use this as your input file , see als info in the script

Hope this will help!

[#6]

Thats really Nice.

I think I had been looking for that only..

Many thanks for your help. Its always learning from you 😛

[#7]

Since you are looking to add only one column, better you try mapping load.Below is the code to do so

Mapping LOAD
rowno() as Month,
'Q' & Ceil(row()/3) as Quarter
Autogenerate (12);

Now use ApplyMap().applymap('Quarters_Map',num(month(date)),Null).It is a temp table.

More info is available in the ref manual.

Incremental load will be used to append records...it is mostly used in monthly-periodical refreshes.