Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a fact table with dates, customers and other expressions
Now i want to connect a table with fare prices
This is a table with faire prices for every customer with a start and end date.
for example :
FarePrice:
LOAD
%PK_Abonnee as %PK_FareAbonnee,
Date(StartDate,'DD-MM-YYYY') as StartDate,
IF(isnull(EndDate)=-1,'31-12-2015',EndDate) as EndDate,
[Fare price]
FROM
.......
Facttable:
Load
%PK_FareAbonnee,
%PK_Date
#...
#.....
How can i connect this tables so i for every date and customer i can get the good fareprice
Who can help me?
Regards,
Dirk
Hi Groen,
Please try this,
Just write the following instruction after the load of the 2 tables.
IntervalMatch (%PK_Date) LOAD StartDate, EndDate Resident FarePrice;
let me know
Hi Groen,
Please try this,
But that works for everydate but not for every date and customer.
Do you understand what i mean.
Could you share your qvw and describe with more details your objective?
Thanks Ganesh, it works,
Regards,
Dirk