cancel
Showing results for 
Search instead for 
Did you mean: 

Concatenate 2 characteristics with a space

Former Member
0 Kudos

Hi gurus,

I have first name and last name but user wants to see both values concatenated with a space in between.

I am trying to do it at DSO to Cube transformation level.

I have joined first name and last name to a single field in the cube and using formula concatenate but unable to put a space between.

Your help will be appreciated.

Thanks.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You can add one infoobject as name in target (cube). In transformation you can map first name and last name coming from DSO to Name infoobject in cube. There you can write a formula and use -

/BIC/fname & ' ' & /BIC/lname

OR

CONCATENATE(/BIC/fname, ,/BIC/lname)

Former Member
0 Kudos

Never mind, got it fixed using a routine in transformation:

Concatenate SOURCE_FIELDS-/BIC/Z_NAME1 SOURCE_FIELDS-/BIC/Z_NAME2

into RESULT separated by space.

Former Member
0 Kudos

Hi,

i got same req now,please can u tell what should in write after RESULT(seprated by space)i didnt got wot you mean

Concatenate SOURCE_FIELDS-/BIC/Z_NAME1 SOURCE_FIELDS-/BIC/Z_NAME2

into RESULT separated by space.

Former Member
0 Kudos

Separated by space is part of code, it will put a space between the 2 characteristics.