Skip to Content
avatar image
-1
Former Member

split values into columns (Calculation View HANA)

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 15, 2017 at 01:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded