3 Replies Latest reply: Apr 2, 2014 3:19 AM by Pier Domenico Muzzi RSS

    Advanced DataSources Merge

      Hi All,

      I have a little difficult with import and merging data from two different datasources.

       

      In the 1th datasource I have a table like this

      IDKeyValue
      1a1
      2b1
      3c3
      4d4
      5e4

       

      In a 2nd datasource I have another table like this

      IDValue
      22
      55

       

      Finally, I want to update the value column in the first table using the corresponding int the 2nd one like this

      IDKeyValue
      1a1
      2b2
      3c3
      4d4
      5e5

       

      I wrote this script but it does not work properly.

       

      Fixed:

      LOAD

          ID

          , Value

      From

          Qvd\Fixed.qvd

          (qvd);

       

      Concatenate (Fixed)

      LOAD

          *

      From

          Qvd\Source.qvd

          (qvd)

      Where Not Exists(ID);

       

      Can someone please help me?

      Thanks a lot.