2 Replies Latest reply: Jul 6, 2018 3:48 PM by Digvijay Singh RSS

    JOIN tables when field values are zero

    Глеб Аитов

      Hi,

       

      Situation: I want to Join OrderId table with Main_Table by [Number] field.

      I want to record Channel/Source/Campaing values from OrderId to the Main_Table (currently there are no values there), where Map = Table2

      Screenshot_4.jpg

      The script:

       

      Left Join (Main_table)


      Load

      'Table2' as map,

      number,

      channel,

      source,

      campaign


      RESIDENT OrderIdSourceTMP;

      Drop Table OrderIdSourceTMP;

       

      The problem is that the tables are not joined because Channel/Source/Campaign in MainTable are considered to exist, although they equal to zero.

       

      Is there a magic sauce?

       

      Thank you!