cancel
Showing results for 
Search instead for 
Did you mean: 

How to Concatenate two fields in Bex Query Designer

manzar_alam
Explorer
0 Kudos


How to Concatenate two fields in Bex Query Designer

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Manzar ,

Concatenation Function  is not possible in BEX Query designer level.   You can try  it with formula variable . But due to perfmornac issue All complex operation should be apply on Backend (Transformation ). 

Regards Vikas

0 Kudos

Please tell me how to do that using formula variable

0 Kudos

Hi Manzar,

Please try user exits to do the operation, If you do not want to disturb data flow.

Regards,

Suresh.

snitwipro
Active Participant
0 Kudos

Yes, it is always better to create such operation at transformation level. Please explain the exact scenario in detail

Regards

Sourav

Former Member
0 Kudos

hi Manzar,

You can't do concatenation at BEx level except for going with Formula Variable. Since this is complex in implementation the better way will be to do it in the back end, transformation.

Regards,

Anupama