No table is created

[MindaugasBacius]

I have a script.

Unfortunately, I cannot figure out what is wrong because map_Tour is an empty table. Actually there is no table after reload.

tmp:
LOAD SY103_WOCHENTAG, 
     SY103_TOUR_NR
FROM
Source
(qvd);

tmp2:
CrossTable(Day, Tour)
LOAD ID, 
     [1], 
     [2], 
     [3], 
     [4], 
     [5], 
     [6], 
     [7]
FROM
Source
(ooxml, embedded labels, table is Points);

Concatenate (tmp)
load distinct ID & '|' & Day as SY103_WOCHENTAG
  ,Tour as SY103_TOUR_NR
Resident tmp2
where not(Exists(SY103_WOCHENTAG, ID & '|' & Day))
;

DROP Table tmp2;

map_Tour:
Load *
Resident tmp;

DROP Table tmp;

When I add any new field in map_Tour I get the table:

map_Tour:
Load *
     ,1
Resident tmp;

But I would like to understand the reasons why the script without any additional field in the map_Tour do not work.

Thank you!

[jerrysvensson · Accepted solution]

Try

map_Tour: 

noconcatenate Load * 

Resident tmp;

[PrashantSangle]

Hi,

Use noconcatenate

because table field in tmp and map_tour contain same field Name there for qlikview automatically concatenate the table.

Regards

[MK_QSL]

1. map_Tour: 
2. Load * 
3. Resident tmp; 
4.  
5. DROP Table tmp;
6. 
   
7. The above table has same fieldname and same column numbers as tmp table so qlikview auto concatenate them.. now when you drop tmp table.. everything getting dropped becuase there is not map_tour table...
8. 
   
9. Use
10. NoConcatenate
11. map_Tour: 
12. Load * 
13. Resident tmp; 
14.  
15. DROP Table tmp;

[MindaugasBacius]

Jerry Svensson

It works fine!

Could you explain it briefly?

When I am not using noconcatenate statement all the data is concatenated and it appears as a part of tmp table?

When dropping tmp I am just removing all the data, am I right?

[jerrysvensson]

Yes, QlikView will auto concatenate tables if they have similar or identical fields.

map_tour will be concatenated to the tmp table and therefore will not be created as a table itself.