Crosstable mapping issue

[YJ_SG]

Hi,

I am new on QlikView. I have a question when map week from sale cross table.

After loaded, it shows two groups of week. I guess one is number, the other is Text. How to join these two together?

Thanks.

Sales:
CrossTable(Week,Sales)
Load * Inline [
Person,201,202,203,204,205,206,207,208,209,210
Jason,100,100,100,100,100,100,100,100,100,900
Peter,200,200,200,200,200,200,200,200,200,600
Johny,300,300,300,300,300,300,300,300,300,500];

Wk2Month:
Load * Inline [
Week,Month
201,Jan
202,Jan
203,Jan
204,Jan
205,Feb
206,Feb
207,Feb
208,Feb
209,Mar
210,Mar];

[Lisa_P · Accepted solution]

Try this:

SalesTemp:
CrossTable(Week,Sales)
Load * Inline [
Person,201,202,203,204,205,206,207,208,209,210
Jason,100,100,100,100,100,100,100,100,100,900
Peter,200,200,200,200,200,200,200,200,200,600
Johny,300,300,300,300,300,300,300,300,300,500];

Wk2Month:
Load * Inline [
Week,Month
201,Jan
202,Jan
203,Jan
204,Jan
205,Feb
206,Feb
207,Feb
208,Feb
209,Mar
210,Mar
];

Sales:
NoConcatenate
Load Person,
Num#([Week]) as Week,
Sales
Resident SalesTemp;

DROP Table SalesTemp;

[YJ_SG]

Thank you Lisa, it works.

I tried to use NUM# to change format but didn't put prefix NoConcatenate before load. Thank you.