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

    Concatenation of String Measure Values and NULLs

    Shantanu Mendhekar

      Hi,

       

      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.

       

      Thanks,
      Shantanu