Qvd file without showing the table in front of fields?

[venkat1]

Hi ,

* ) i Had loaded a from Data Base and saved into Qvd file with naming a table, i loaded it again ,which was look like this

LOAD yr.J_YEAR,
yr.YEAR_1,
yr.QUARTER,
yr.MONTH_NAME,
yr.MONTH_SORTER
FROM
[C:\Users\qlik\Desktop\Updated QVD\yr.qvd]
(qvd);

similar way i had loaded another old QVD File which is converted from the Data Base ,

RM:
QUALIFY *;
UNQUALIFY BRANCH_CLEAN;

LOAD REGION,
BRANCH AS BRANCH_CLEAN,
CHANNEL,
BRANCH_CODE,
OPENING,
AREA
FROM
[D:\DATA\QVD\XXPOS_REGION_MASTER.qvd]
(qvd);

By loading the seconf qvd file i had not seen the fields like yr.Quarter which looks like in the fist loaded script

[Gysbert_Wassenaar]

What's your question?

[venkat1]

LOAD yr.J_YEAR,
yr.YEAR_1,
yr.QUARTER,
yr.MONTH_NAME,
yr.MONTH_SORTER
FROM
[C:\Users\qlik\Desktop\Updated QVD\yr.qvd]
(qvd);

if i upload this qvd 

before fields yr. should not come for each and every fields .

[Gysbert_Wassenaar]

The fields in the qvd already have those names then. All you can do is rename the fields when you load the data from the qvd.

[venkat1]

YR:
QUALIFY *;
LOAD J_YEAR,
YEAR_1,
QUARTER,
MONTH_NAME,
MONTH_SORTER
FROM
[C:\Users\qlik\Desktop\Updated QVD\yr.qvd]
(qvd);

i edited like this and reloaded it was throwing the error .

[Gysbert_Wassenaar]

Use the 'as' keyword to rename fields:

LOAD 
	yr.J_YEAR	as J_YEAR,
	yr.YEAR_1	as YEAR_1,
	yr.QUARTER      as QUARTER,
	yr.MONTH_NAME	as MONTH_NAME,
	yr.MONTH_SORTER	as MONTH_SORTER
FROM
	[C:\Users\qlik\Desktop\Updated QVD\yr.qvd]
	(qvd)
	;