Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to replace join by applymap ?
load * FROM E:\QVD\QVD\VenteFull.qvd (qvd); LEFT JOIN(Vente) IntervalMatch (datecol, [Code Site], [Code Article]) LOAD DISTINCT DateDebutPermanent, DateFinPermanent, [Code Site], [Code Article] resident Permanent ; LEFT JOIN (Vente) LOAD * RESIDENT Permanent;
load *
FROM
E:\QVD\QVD\VenteFull.qvd
(qvd);
LEFT JOIN(Vente)
IntervalMatch (datecol, [Code Site], [Code Article])
LOAD DISTINCT DateDebutPermanent, DateFinPermanent, [Code Site], [Code Article]
resident Permanent
;
LEFT JOIN (Vente)
LOAD *
RESIDENT Permanent;
Dunno.
How many columns from Permanent are being joined into Vente? Every additional column needs a separate mapping table and applymap call. Are you really sure you want to replace this compact piece of script code? Too many records in table Vente?
