hi

[#1]

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

[senpradip007]

You can just concatenate the excel file having YEAR field.

[arulsettu]

hi

load year field and reload the script.

[#4]

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.

[#5]

hi to all,

      Thanks for giving valuable suggestions,may be lonut explenation is good i ll follow this.