Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the follwoing script
sales : Load * from test.qvd ; LEFT JOIN(sales ) IntervalMatch (datecol) LOAD DISTINCT [DATE DEBUT] ,[DATE FIN] resident OC ; LEFT JOIN (sales ) LOAD * RESIDENT OC;
sales :
Load *
from test.qvd ;
LEFT JOIN(sales )
IntervalMatch (datecol)
LOAD DISTINCT [DATE DEBUT]
,[DATE FIN]
resident OC
;
LEFT JOIN (sales )
LOAD *
RESIDENT OC;
I got duplicates rows . so how to Join to first row in qlikview ?
Add one more line
Drop Table OC;