Concatenate fields in a hierarchy

[#1]

     Hi

I have created a dim table based on hierarcy tag.  Is it possible to concatenate two fields so I can display the code and description.

Thanks

[#2]

use code&' '&description as Code

[#3]

Thanks. Would this be in the load statement?

[#4]

Yes.

You can also do this in front end depends on your requirement.

[#5]

This is what I have and you will note I have put the concatenate in the Load statement  but it fails load.

Hierarchy (LocalServiceLine, LocalServiceLineParent, LocalServiceLineDescription, , LocalServiceLineDescription,'\', 'HIEARACHY DEPTH')

LOAD LocalServiceLine & ''& LocalServiceLineDescription AS Line,

  LocalServiceLineParent,

  LocalServiceLineDescription

  Resident DIMLocalServiceLine;

  Drop table DIMLocalServiceLine;

RENAME Fields LocalServiceLineDescription1  to Trust, LocalServiceLineDescription2 to Division, LocalServiceLineDescription3 to Specialty;

[#6]

Can you share QVW

[#7]

I have managed to do it within the app as that was easier. 

[#8]

How can i share the QVW