3 Replies Latest reply on Jul 3, 2018 11:34 AM by Deepak Rai

    Join based on a range of values

    Matt Wilson

      Table1 contains balance sheet mapping instructions.

      Table2 contains actual balance sheet accounts.

      I'm looking to Left join Table1 to Table2 so that I will be able to see the "SAGE Mapping" for each "Base" listed in Table2. Results should be as follows:

       

       

         1) can this be accomplished through a join?

         2) could it be accomplished through some sort of lookup on un-joined data sources?

       

      Thanks in advance.