6 Replies Latest reply: Mar 23, 2017 10:02 AM by Dave Riley RSS

    Residents Join when there is no common column

    Sandhya Sunkula

      Hi ,

       

      I have 2 Residents X and Y,

       

      Resident X
      CategoryStartEnd
      A15
      B610
      C1114

        

       

       

      Resident Y
      AccountAmount
      1100
      2101
      3102
      4103
      5104
      6105
      7106
      8107
      9108
      10109
      11110
      12111
      13112
      14113

       

      There is no common column between these two Residents, But I need to check if Account is in between Start and End of Resident X, then I should pull Category into Resident Y.

      I need data like below

       

       

      Final Resident Z
      CategoryAccountAmount
      A1100
      A2101
      A3102
      A4103
      A5104
      B6105
      B7106
      B8107
      B9108
      B10109
      C11110
      C12111
      C13112
      C14113

       

      Can any one help me with this?