topic Re: No table is created in QlikView

No table is created

MindaugasBacius — Tue, 28 Jun 2016 09:52:03 GMT

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 *

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!

Re: No table is created

jerrysvensson — Tue, 28 Jun 2016 09:53:44 GMT

Try

map_Tour:

noconcatenate Load *

Resident tmp;

Re: No table is created

PrashantSangle — Tue, 28 Jun 2016 09:56:24 GMT

Hi,

Use noconcatenate

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

Regards

Re: No table is created

MK_QSL — Tue, 28 Jun 2016 09:59:02 GMT

map_Tour:
Load *
Resident tmp;
DROP Table tmp;
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...
Use
NoConcatenate
map_Tour:
Load *
Resident tmp;
DROP Table tmp;

Re: No table is created

MindaugasBacius — Tue, 28 Jun 2016 10:00:19 GMT

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?

Re: No table is created

jerrysvensson — Tue, 28 Jun 2016 10:04:43 GMT

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.