Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
emmanuelanurag
Contributor II
Contributor II

have to concatenate one of the field in QVD

I loaded the data from the SQL server to QVD files and i concatenated all the QVD files to generate the data , but my issue is that i am unable to segregate the total values i got from each table. below is the QVD & i need the field "comment" contains data that should start from table name. for example field "comment" is having a value " zinc" then i need that to be displayed as "TVREP_8025 ZINC". please help me out.

LOAD
zSource,
MANDT,
KUNNR,
VKORG,
VTWEG,
SPART,
KTOKD,
LAND1,
PRAT3,
KALKS,
"Comment",
IsError
FROM [QVD Storage/TVREP_8025.qvd]
(qvd)

Labels (1)
1 Reply
anat
Master
Master

"Comment"&subfield(filename(),'.',1)