Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try
map_Tour:
noconcatenate Load *
Resident tmp;
Hi,
Use noconcatenate
because table field in tmp and map_tour contain same field Name there for qlikview automatically concatenate the table.
Regards
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?
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.