Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Update a table in qlikview with values from a spreadsheet

Hi,

I'm trying to work out the best way to update a table in qlikview with values from a spreadsheet.

I have a table called Data:

ID        MonthYear        Value

1          Apr 2012          10

1          May 2012         13

1          Jun 2012           9

2          Apr 2012          12

2          May 2012         18

2          Jun 2012           2

3          Apr 2012          32

3          May 2012         12

3          Jun 2012           1

I also have a spreadsheet called Amendments:

ID          MonthYear          Value

1           May 2012            10

1          Jun 2012               8

2          Apr 2012              20

3          Jun 2012              15

I want to import the spreadsheet table and overight the values in the Data table.

This sis just an example, i actually need to this to 1000s of rows.

Cheers

Simon

3 Replies
MK_QSL
MVP
MVP

What could be your end result in above table?

yduval75
Partner - Creator III
Partner - Creator III

You need to import your file in the script by this way

MK_QSL
MVP
MVP

FINAL:

Load *, ID&MonthYear as Key Inline

[

  ID, MonthYear, Value

  1,  May 2012,  10

  1,  Jun 2012,   8

  2,  Apr 2012,  20

  3,  Jun 2012,  15

];

Concatenate

Load *, ID&MonthYear as Key Inline

[

  ID, MonthYear,Value

  1,  Apr 2012, 10

  1,  May 2012, 13

  1,  Jun 2012,  9

  2,  Apr 2012, 12

  2,  May 2012, 18

  2,  Jun 2012,  2

  3,  Apr 2012, 32

  3,  May 2012, 12

  3,  Jun 2012,  1

] Where NOT Exists (Key, ID&MonthYear);