topic Re: Filed missing after intermatch in QlikView

Filed missing after intermatch

Anonymous — Tue, 27 Oct 2015 09:06:12 GMT

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;

Re: Filed missing after intermatch

MK_QSL — Tue, 27 Oct 2015 09:13:40 GMT

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.

Re: Filed missing after intermatch

sujeetsingh — Tue, 27 Oct 2015 09:21:40 GMT

May be some nulls in source.

Re: Filed missing after intermatch

miguelbraga — Tue, 27 Oct 2015 09:22:26 GMT

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,

Re: Filed missing after intermatch

Anonymous — Tue, 27 Oct 2015 09:25:36 GMT

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

Re: Filed missing after intermatch

marcus_malinow — Tue, 27 Oct 2015 10:11:31 GMT

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;