Skip to Content
-1

split values into columns (Calculation View HANA)

Nov 15, 2017 at 10:55 AM

106

avatar image
Former Member

Hi Guys,

im absolute beginner with HANA Modelling, i have an issue that i want to split this values into 3 columns:

at the end should be like this:

CHAR01 | CHAR02 | CHAR03

investplan | 2015000 | ID

is there any function which i can use ??

thank you for ur help

BR

Gary

hana-values.png (4.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Nov 15, 2017 at 01:31 PM
0

In a calculation view you can create three projection nodes on your projection node which supplies the data you described.

Each projection has to filter on a specific value in column "CHAR_VALUE" (the first one one 'PROJECT', the second one one on /ISV/IOIVPLYR', the third one on 'CHART'.

With that you have separated the values which you can join together in a join node.

Regards,
Florian

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hallo Mr. Florian Pfeffer,

thank you for ur help.

Regards.

Gary

1