topic Merge Rows in App Development

Merge Rows

sarasmonu — Thu, 26 Apr 2018 16:25:28 GMT

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 — Thu, 26 Apr 2018 17:19:15 GMT

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 , '/' )