9 Replies Latest reply: Aug 22, 2014 7:35 AM by Yurii Ratushnyi RSS

    Upload new data and replace old one

    Yurii Ratushnyi

      Hi all,

       

      I load new data every day and need not just concatenate it to previous one, but also make changes in old data according to a new data. Here is an example of tables

       

      load * Inline [

      a, b

      1,2

      2,3

      3,8

      ];

      load * Inline [

      a, b

      1,5

      2,3

      4,3

      5,4

      ];

       

      As a result of joining/concatenating them I would like to have

       

      a, b

      1,5

      2,3

      3,8

      4,3

      5,4

       

      How can I do that?