Hi,
The script below takes a long time to load. Anybody knows how to optimize the load?
The purpose of the script is to create a table with sale_ids that contains two specific salesnames on the same date.
chkIdDate:
LOAD chkIdDate
Where Count=2;
LOAD chkIdDate,
count(distinct id_salesname) as Count
group by chkIdDate;
LOAD Id_sale &'_'&id_date as chkIdDate
,id_salesname
FROM...
where
(Applymap('Apply_department', id_department, ':') <> ':')
and
(Applymap('Apply_salesname', id_salesname, ':') <> ':')
;