Problem with load resident data from crosstable

[#1]

Hi All.

I have a table:

Name	January	February	March
Name 1	10	20	30
Name 2	40	50	60

When I load this table and make a crosstable, I see next table:

Name	Month	Data
Name 1	January	10
Name 1	February	20
...	...	...
Name 2	March	60

Script:

First_table:

CrossTable(Month, Data)

LOAD Name,

     January,

     February,

      March

FROM (XLS file with deleted rows and columns)

It's OK and work great.

But later, i want create a new table from crosstable:

New_table:

LOAD Name,

     Data,

     Month

Resident First_table;

DROP Table First_table;

And I don't see any table. Clear. No New_table, no First_table.

Where a mistake? I don't understand.

I must load all columns from crosstable in other new table.

Thank you.

[tresesco · Accepted solution]

Your second table is getting concatenated and then dropped with the first one. You have to use NoConcatenate key like:

First_table:

CrossTable(Month, Data)

LOAD Name,

     January,

     February,

      March

FROM (XLS file with deleted rows and columns)

NoConcatenate        

New_table:

LOAD Name,

     Data,

     Month

Resident First_table;

DROP Table First_table;

[#3]

Add Noconcatenate just before Load in the Second table...

Qlikview is automatically concatenating second table to 1st table as fields are of same name.

Regards,
Dawar

[#4]

Tresesco, thak you very much.

It's work!