4 Replies Latest reply on Sep 8, 2017 5:16 AM by Michael Murphy

    Calculated Join Clause Not Working

    Michael Murphy

      All,

       

      Thank you for the help!

       

      I attached a workbook relating to my question...

       

      Both fields below are sub string calculations that produce the same value. However, when I try to join on these calculations it does not work. If you go to the data source tab within the workbook attached you will be able to see that an inner join does not produce any results. If you select full outer join you can see the values.

       

      Archer Calc

      Notes Calc

       

      Please help!!!!