Filed missing after intermatch

[Anonymous]

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;

[MK_QSL]

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.

[sujeetsingh]

May be some nulls in source.

[miguelbraga]

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

[Anonymous]

when I remove drop table OCtemp; I get the best results

[marcus_malinow · Accepted solution]

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;