1 Reply Latest reply: Jul 11, 2018 8:30 AM by Luca Bellotti RSS

    Joining two tables

    Luca Bellotti

      Hi everyone,

      I need to join (or keep I honestly don't know) two tables.

       

      TABLE_1

      CODE_STORECODE_DEPDATESALES
      A102/01/2018100

      A

      103/01/201850
      A201/01/201875
      A202/01/201825
      A301/01/2018100
      A401/01/2018100

       

      TABLE_2

      CODE_STORECODE_DEPCODE_DEP2WEIGHT_%CODE_DEP_MINDESC_DEP_MINDEP_MIN

      A

      1

      1a30%01RED01 - RED
      A11b70%02BLUE02 - BLUE
      A11a30%01RED01 - RED
      A11b70%02BLUE02 - BLUE
      A22a50%03YELLOW03 - YELLOW
      A22b50%04GREEN04 - GREEN
      A22a50%03YELLOW03 - YELLOW
      A22b50%04GREEN04 - GREEN
      A33a40%05ORANGE05 - ORANGE
      A33b60%06BROWN06 - BROWN
      A44a20%07BLACK07 - BLACK
      A44b80%08WHITE08 - WHITE

       

      What I need to get is something like this

      CODE_STORECODE_DEPDATESALESCODE_DEP2WEIGHT_%CODE_DEP_MINDESC_DEP_MINDEP_MIN

      A

      1

      02/01/20181001a30%01RED01 - RED
      A102/01/20181001b70%02BLUE02 - BLUE
      A103/01/2018501a30%01RED01 - RED
      A103/01/2018501b70%02BLUE02 - BLUE
      A201/01/2018752a50%03YELLOW03 - YELLOW
      A201/01/2018752b50%04GREEN04 - GREEN
      A202/01/2018252a50%03YELLOW03 - YELLOW
      A202/01/2018252b50%04GREEN04 - GREEN
      A301/01/20181003a40%05ORANGE05 - ORANGE
      A301/01/20181003b60%06BROWN06 - BROWN
      A401/01/20181004a20%07BLACK07 - BLACK
      A401/01/20181004b80%08WHITE08 - WHITE

       

      Any suggestions on how can I get this?

       

      Thank you

        • Re: Joining two tables
          Luca Bellotti

          I've managed to join the two tables by myself.

          Here's my solution to the problem

           

          TABLE_3:

          NoConcatenate

          Load *

          Resident TABLE_2;

          left join (TABLE_3)

          Load *

          Resident TABLE_1;

          Drop Table TABLE_1;

          Drop Table TABLE_2;


          If anybody else has a better solution let me know.

          Thanks again.