topic Re: hi in QlikView

hi

Tue, 20 Jan 2015 07:22:13 GMT

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

Re: hi

senpradip007 — Tue, 20 Jan 2015 07:25:03 GMT

You can just concatenate the excel file having YEAR field.

Re: hi

arulsettu — Tue, 20 Jan 2015 07:29:24 GMT

load year field and reload the script.

Re: hi

Tue, 20 Jan 2015 07:53:40 GMT

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.

Re: hi

Tue, 20 Jan 2015 08:47:24 GMT

hi to all,

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