Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 .
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 .
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) ;