1 Reply Latest reply: Oct 12, 2015 8:22 AM by Mindaugas Kašalynas RSS

    combining one table from few, with one common field, filling in data from different sources

      hello guys,

       

      trying allways to search berofe asking and ussualy it works not now...

       

      i am working of messy data set where regarding on origin of the data (ID field) i need to fill in one column (code) from many tables.

       

      Here is the situation:

         

      table1
      codedescriptionidamount
      -112
      -212
      -312
      -code [a4]434
      -code [a5]523
      -code [a6]613
      --735
      --846
      --946

       

      p.s. using subfield (description) i know how to extract code.

         

      table 2
      idcode
      7a7
      8a8
      9a9

       

         

      table 3
      idcode
      1a1
      2a2
      3a3

       

      I want to create new table, or fill in TABLE 1 to have this data:

       

         

      NEW table
      code_combinedamount
      a112
      a212
      a312
      a434
      a523
      a613
      a735
      a846
      a946

       

      Tried to use left join, but data from Table 2 and Table 3 starts to "fight", first loaded - wins. Other IDs remains empty.

       

      Any ideas?