Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use code&' '&description as Code
Thanks. Would this be in the load statement?
Yes.
You can also do this in front end depends on your requirement.
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;
Can you share QVW
I have managed to do it within the app as that was easier.
How can i share the QVW