8 Replies Latest reply: Nov 3, 2014 10:30 AM by Neha Potdar RSS

    MID / Textbetween Issue

    Neha Potdar

      Hi,

       

      I have 2 tables with the join Table1.Substring (col1,1,4) = Table2.ID.

       

      I am writing MID in the load statement for table 1 as:  Load MID (col1,1,4) AS ID. Would this join work? Because I cannot see both table's data together. Either one of the tables data is displayed. One of the table shows blank data when other one displays data.

       

      Thanks,

      Neha