sarasmonu
Creator
2018-04-26
12:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Merge Rows
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
948 Views
1 Reply
petter
Partner - Champion III
2018-04-26
01:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 , '/' )
870 Views