Problem with saving entire file

[#1]

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?

[martin59]

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

[#3]

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?

[martin59]

Have you saved your file after reload ?

[#5]

Hi,

Use the keyword NOCONCATENATE

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

[#6]

Yes, after reload file was saved.