topic Re. :Re: Re. :Problem with saving entire file in QlikView

Problem with saving entire file

Fri, 13 Aug 2010 13:46:04 GMT

Hi,

I have a problem with saving entire file.
After manual reloading I see all needed data. I close the file and open it again. After opening the file, I can only see part of the data.

Scritp looks like below:

sp2mag_:

LOAD DISTINCT //this part of data I see
SP_MAG_KEY as KEY,
KTM as KTM1,
[Producent ID] as PROD,
[Magazyn ID] as MAG
RESIDENT Sprzeda?Szczegó?y_;

LOAD DISTINCT //this part of data is disabled after openning the file
SP_MAG_KEY as KEY,
KTM as KTM1,
[Producent ID] as PROD,
[Magazyn ID] as MAG
RESIDENT mg_stan_magazynu;

sp2mag:LOAD DISTINCT
KEY as SP_MAG_KEY,
KTM1 as KTM,
PROD as [Producent ID],
MAG as [Magazyn ID]
RESIDENT sp2mag_;

DROP FIELD KTM,[Producent ID],[Magazyn ID] FROM Sprzeda?Szczegó?y_;
DROP FIELD KTM,[Producent ID],[Magazyn ID] FROM mg_stan_magazynu;
DROP TABLE sp2mag_;

Could you help me please, what I'am doing bad?

Re. :Problem with saving entire file

martin59 — Fri, 13 Aug 2010 13:58:13 GMT

Hi, your table named "mg_stan_magazynu" is automatically concatened with your first table loaded because it has got the same number of fields and same fields names.

Your data are in the end of your first table

Re. :Problem with saving entire file

Fri, 13 Aug 2010 14:02:45 GMT

Yes, I know. As you see I need this data is one table, but why after reopen the file, part of data is not showed?

Re. :Re: Re. :Problem with saving entire file

martin59 — Fri, 13 Aug 2010 14:12:50 GMT

Have you saved your file after reload ?

Problem with saving entire file

Fri, 13 Aug 2010 14:13:49 GMT

Hi,

Use the keyword NOCONCATENATE

NOCONCATENATE
LOAD DISTINCT //this part of data is disabled after openning the file
SP_MAG_KEY as KEY,
...

Re. :Re: Re. :Problem with saving entire file

Fri, 13 Aug 2010 14:23:56 GMT

Yes, after reload file was saved.