Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
alreadyi loaded yesterday one table means i ve columns like this region,branch,item,main type,sub type,model,design like this i ve in excel formatt and today i added one column ---> year in excel.. if i want load this YEAR column to Qlikview script
what i have to do
Thanks in advance
chandra
You can just concatenate the excel file having YEAR field.
hi
load year field and reload the script.
Hey,
If you are loading something like:
YourTable:
Load
*
From [YourExcelFile];
You shouldn't have any problem with adding the YEAR field, by reloading you will automatically add the YEAR field.
If you are loading like:
YourTable:
Load
YourField1,
YourField2,
...
YourFieldn
,YEAR
From [YourExcelFile];
Add what is written in Italic, the column YEAR, in your selected rows, and reload the document.
hi to all,
Thanks for giving valuable suggestions,may be lonut explenation is good i ll follow this.