5 Replies Latest reply: Jan 31, 2017 2:42 PM by Stefan Wühl RSS

    concat only first X records

    Evgeny Stuchalkin

      Hello! I have table:

       

      userIDDealID
      11
      12
      13
      14
      15

       

      In visual layer, i want use concat function to get measure like this:

       

      userIDDealID
      11;2;3;4

       

      And, i want restrict Concat formula to take only first 4 DealID. How to make this?