Discussion Board for collaboration related to Creating Analytics for QlikView.
in load script i load two tables from xlsx files:
(biff, embedded labels, table is [WDays$])
where Дата < today(1);
(biff, embedded labels, table is [WShedule$]);
They have the same field Work_schedule.
Tell me please, how to join these two tables into third (other table) by field Work_schedule and drop tables?
load * resident WorkingDays;
drop table WorkingDays;
load * resident WorkingShedule;
drop table WorkingShedule;
load * resident WorkingDaystmp;
load * resident WorkingSheduletmp;
drop table WorkingDaystmp;
drop table WorkingSheduletmp;
in the case you don't drop the tables at the end, use NOconcatenate just before finaltable:
You do not need a join.
The two tables have a common field Work_schedule, you can just load each table and QlikView will automatically associate the two tables on the common field name.
You rarely need to use joins in QlikView.
A better solution would be to use a Mapping Table because the working schedule table only has two columns.
The mapping table is automatically deleted when the script finishes leaving just the WorkingDays table.
ApplyMap('WorkingSchedule_map', Work_schedule) as Distributor,