Skip to Content
avatar image
Former Member

Block output

Hi all,

I have 2 dimensions: [Title] and [Category]

Title Category A Cat01 A Cat02 B Cat01 B Cat03

i want to output as follow:

Title Category A Cat01, Cat02 B Cat01, Cat03

How can i achieve this?

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 25, 2014 at 03:07 PM

    Hi,

    You can do it like this;

    =[Category]+", "+RelativeValue([Category];([Category]);+1)

    Regards,

    Utku

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 07:42 AM

    anyone help me please! 😭

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 07:11 AM

    Hi,

    I come up with another solution.

    I made this at universe's level (data foundation).

    I created derived table List of categories on data foundation.

    SELECT TITLES.TITLE, LISTAGG(CATEGORIES.CATEGORY, ',') WITHIN GROUP (ORDER BY CATEGORIES.CATEGORY) as Categories

    FROM CATEGORIES LEFT JOIN TITLES

    ON TITLES.MAT_ID = CATEGORIES.MAT_ID

    GROUP BY TITLES.TITLE

    However, it caused an error "ORA-01489: result of string concatenation is too long"

    Anyone know how to solve this error?

    Add comment
    10|10000 characters needed characters exceeded