Merge Rows

[sarasmonu]

Hi All,

Below is the scenario.

I have 2 rows with multiple columns exactly same except one.

Example:

Input:

ColA    ColB   ColC   ColD

1          Std      Thur    ABC

1          Std      Thur    PQR

Expected Output:

ColA    ColB   ColC   ColD

1          Std      Thur    ABC/PQR

Please help.

Thanks,

Monu

[petter]

In a load script you can do it like this:

LOAD

  ColA,

  ColB,

ColC,

Concat( ColD , '/') AS ColD

FROM

Input

GROUP BY

ColA, ColB, ColC;

If you need to do it directly in a table in the UI of an application you can:

Add the columns ColA, ColB and ColC as dimensions.

Add the measure with the expression

    Concat( ColD , '/' )