6 Replies Latest reply: Aug 5, 2013 12:06 PM by Tony Yang RSS

    Question about joins.

      Hi Guys,

       

      Can anyone out there help me solve this issue I have?

       

      Please see below

       

      A:

      LOAD * INLINE [

      Name, ID

      abc123Abandoned Cart_xiyudhu289192, 58973

      asdasd234Abandoned Cart_xihu282392, 58975

      xsasdass293tBrowers_dhu23432, 56456

      ];

       

       

      B:

      LOAD * INLINE [

      CampaignName, Cost, Date

      Abandoned Cart, 3108, 41468

      Browers, 827, 41468

      ];

       

       

      Result Needed

       

      1 Table That looks like

       

      Name

      ID

      Cost

      Date

      abc123Abandoned Cart_xiyudhu289192

      58973

      3108

      41468

      asdasd234Abandoned Cart_xihu282392

      58973

      3108

      41468

      xsasdass293tBrowers_dhu23432

      56456

      827

      41468

       

      I can't seem to join the two tables where i need to do some sort of dyname string match. 

       

      Please help!

       

      Thanks.