Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when I execute the following script I didn't find the field oc after intermatch in the table TempVente
How to resolve it ?
OCtemp:
LOAD [OC] ,DEBUT
,FIN ;
SQL SELECT distinct [OC]
,[DATE DEBUT] AS [DEBUT]
,[DATE FIN] AS [FIN]
FROM [QlikDataWarehouse].[dbo].[OC]
WHERE [Code Article] IS NOT NULL ;
TempVente:
LOAD PrixUnitaireArticle,
PrixArticleHT,
datecol,
PrixRevientTTC
FROM
E:\QVD TEST OC\Vente.qvd
(qvd);
LEFT JOIN(TempVente)
IntervalMatch (datecol)
LOAD DISTINCT DEBUT
,FIN
resident OCtemp
;
drop table OCtemp;
You've already posted several variations of this question, and have been given the answer already.
Before DROP TABLE OCTemp
LEFT JOIN (TempVente)
LOAD *
RESIDENT OCTemp;
You need to provide some more information? May be a sample data file (excel file) or a sample QVW is good to work on your question.
May be some nulls in source.
Hi mate,
I'm sorry but I didn't understood your question. Can you please elaborate better? By the way, OC is a table not a field. I don't know where you have your desired field.
Regards,
MB
when I remove drop table OCtemp; I get the best results
You've already posted several variations of this question, and have been given the answer already.
Before DROP TABLE OCTemp
LEFT JOIN (TempVente)
LOAD *
RESIDENT OCTemp;