IntervalMatch

Wed, 23 May 2012 17:51:50 GMT

Hello,

I have two files Excel and i would like to match a column

For example

Mod_Comm:

Load Client,

Produit,

TicketPesee as Pesee,

Date

From Comm.xls

Mod_Pont:

Load Pont_Client,

Pont_Produit,

Pont_Pesee as Pesee,

Pont_Date

From Pont.xls

intervalmatch (Pesee) load Client, Produit resident Mod_Comm;

intervalmatch(Pesee) load Pont_Client, Pont_Produit resident Mod_Pont;

This script returns errors. please help me

Cdt,

Re: IntervalMatch

Wed, 23 May 2012 18:15:34 GMT

What is your reasoning for using intervalmatch here? Typically, intervalmatch is used to solve the, "problem of slowly changing dimensions in source data." (QV Reference Manual). Are you trying to solve for that problem or just join the tables together?

topic Re: IntervalMatch in QlikView

IntervalMatch

Re: IntervalMatch