Webi Intelligence Report

[Former Member]

HI All

We have issue in the webi report . we have two columns in the report .

and the result will be like below.

Col 1     Col 2

    X          1

    X          2

    X          3

    Y          5

    Y          6

Now we want the result to be

Col 1     Col 2

   X         1,2,3

   Y          6,3

Is this possible, if yes how ?

[Former Member]

Hi Arun,

If you want to achieve it at the universe level then

1) create Measure object of your col2

as col2+","

2) Set the projection option as Sum

3) If your col2 is character data type then make sure the data type of the object as character

4) Save and export the universe

5) Remove the last comma by creating a variable at the report level using substring function

If you want to achieve at the report level pls look into below threads

bi.scribe: Converting rows into a single cell (comma separated list) in WebI

[former_member196948]

Try below links

bi.scribe: Converting rows into a single cell (comma separated list) in WebI

http://stackoverflow.com/questions/32996959/concatenate-multiple-rows-data-in-single-cell-in-a-webi-...

Regards,

Jeet

[former_member198519]

Try the suggestion mentioned in this blog:

[Former Member]

Hello Arun,

Please refer to below thread.

Regards

Niraj