Creating a column "Year" on the Script, and adding those register to other Years.

Fri, 12 Apr 2013 12:57:26 GMT

Hi, i have this problem:

I have two excel documents: the first one I have a history, from 2005-2012, with company names that other company supports. I have one other, with only 2013 company names, that this other company support. So, it's like this the first Excel document (2005-2012):

Year Company Name

2005 A

2005 B

2005 C

2006 A

2006 B

2006 C

The second document i don't have the column Year. I have only the company names. I need to create a column, on Qlikview, that will show '2013' in the year, followed by the Names. The final, i would like to appear like this:

Year Company Name

2005 A

2005 B

2005 C

2006 A

2006 B

2006 C

... ...

2013 A

2013 B

2013 C

I've been trying to use the comand "year()", but it returns to me weird Dates (for example: year(2013) returns "1905"). Some other attempts, didn't work well, due to the fact that i need to create the field "year 2013" and put it together with the names and add it to the Year.

Re: Creating a column "Year" on the Script, and adding those register to other Years.

Gysbert_Wassenaar — Fri, 12 Apr 2013 14:19:53 GMT

Something like this:

MyTable:

load Year, [Company Name]

from ...myexcelfile...;

load 2013 as Year, [Company Name]

from ...myotherfile...;

topic Re: Creating a column "Year" on the Script, and adding those register to other Years. in QlikView

Creating a column "Year" on the Script, and adding those register to other Years.

Re: Creating a column "Year" on the Script, and adding those register to other Years.