Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-05-23 01:51 PM

IntervalMatch

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,

459 Views
0 Likes
1 Reply
Not applicable
‎2012-05-23 02:15 PM
Author

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?

272 Views
0 Likes