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)
