3 Replies Latest reply: Apr 4, 2014 11:28 AM by Manish Kachhia RSS

    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