Prefix code to calendar days

[tamilarasu]

Hi,

I have created a 3 years calendar table by using load script and total of 1096 days. Now, I want to add 20 country codes to each date. I am not sure how to achieve this as I am new to Qlikview.

For Ex:

               

Likewise I need to prefix the 20 country code to all 1096 days.

Thanks in advance.

[jagan · Accepted solution]

Hi,

Try this script

Temp:

LOAD

*

INLINE [

Country

India

USA

UK];

JOIN

LOAD

*

INLINE [

Date

1/1/2014

1/2/2014

1/3/2014];

Data:

LOAD

*,

Country & Date AS Key

RESIDENT Temp;

DROP TABLE Temp;

Hope this helps you.

Regards,

jagan.

[anbu1984]

Final_Calendar:

Load

Country,FKDAT,

  Country &''& FKDAT as SalesOrgDate

  Resident Country;

[tamilarasu]

Hi Jagan. Working fine now. Thank you.

[tamilarasu]

Thank you all.