Skip to Content
0

Convert Rows to Columns Dynamically based on the Source Column

Feb 22, 2017 at 05:36 AM

35

avatar image

Hi HANA Gurus,

I have got very challenging requirement to convert the rows in columns.

EVENTID COST_CLASS AMOUNT

EV001 DR 280

EV001 CM 320

EV001 PR 320

EV001 WM 120

EV002 AB 280

EV002 SL 300

EV003 WM 500

EV004 S00 100

EV004 EOO 280

EV005 CD 240

EV006 DR 100

EV006 CO 90

EV006 MA 3,000

EV006 WM 280

Target: I have written only one eventid row as event id will be the input parameter

EVENTID DR CM PR WM

EV001 280 320 320 120

Actually Here COST_CLASS has different values for Each Event ID and EVENT_ID will be the input parameter from UI, based on the UI Input parameter view should return the results.

I tried multiple ways to achieve this but not got through it and fine with Graphical view /scripted calc view/table function. Could you please help in this .

Thanks in Advance ,

Asif

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers