IntervalMatch

[#1]

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,

[#2]

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?