on 11-24-2023 6:10 AM
Hi,
I want to use this formula:
CONCAT(LIFNR,NAME1)
CONCAT(LIFNR," ",NAME1)
CONCAT(LIFNR,"",NAME1)
CONCAT(LIFNR,'',NAME1)
CONCAT(LIFNR,' ',NAME1)
Hi Martin,
DSP purely use the built-in function and operator of HANA, just try this:
LIFNR || ' ' || NAME1
Regards,
Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Simon,
Thank you so much, it worked perfectly!
One question for future reference, what "coding language" is Datasphere Model View calculated columns based on?
I often try to use ChatGPT to solve this, but it doesn't have data for this kind of solutions and always have to turn my questions to here.
I modified the code a little. To make it look better in visualisation part.
LIFNR || ' | ' || NAME1
It's the HANA SQL language, you can refer to the document:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.