topic Re: Problem with load resident data from crosstable in QlikView

Problem with load resident data from crosstable

Wed, 20 Aug 2014 08:00:13 GMT

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.

Re: Problem with load resident data from crosstable

tresB — Wed, 20 Aug 2014 08:05:32 GMT

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;

Re: Problem with load resident data from crosstable

Wed, 20 Aug 2014 08:12:14 GMT

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

Re: Problem with load resident data from crosstable

Wed, 20 Aug 2014 08:14:28 GMT

Tresesco, thak you very much.

It's work!