4 Replies Latest reply on Feb 26, 2016 11:28 AM by Shantanu Mendhekar

    Concatenation of String Measure Values and NULLs

    Shantanu Mendhekar



      I am trying to concatenate the different supplier names for a material from the data source. So, basically below is how the data source appears

      and below is how the final concatenation should work.


      I am able to achieve the required results by using the solution in another thread here - Re: Concatenating data from child rows


      The problem arises when I try to use the above results with  the data that I want it to be displayed along.


      Below is how my other source data looks


      And below is how it looks after I use the solution.


      Ideally, I expect to see just another column in there with the different supplier names concatenated, but somehow NULL is getting involved in there.


      Can you suggest a workaround? Please check the attached workbook.