Discussion board where members can get started with QlikView.
I Have been having trouble with interval matching. I have two tables. One that has the Date intervals call it IntervalTable,
and a second table with the dates call it FactTable. Both tables have a key in common and the FactTable also has another field that is just a counter (could be something else).
I just made up some tables to illustrate the problem. The FinalTable is what I want. When I try I either lose some data or my track field is wrong.
What I have tried so far is.
Load Field, Start, End, Fruit
Load Date, Field, Counter
Intervalmatch(Date, Field) Left Join
Load Start, End, Field
Left Join (FactTable)
Drop Table IntervalTable;
Go to Solution.
Try the following. See also Slowly Changing Dimensions
Load Field, Start, End, Fruit,
Field & '|' & Start & '|' & End as IntervalKey
Load Date, Field, Counter,
Field & '|' & Date as DateKey
Field & '|' & Start & '|' & End as IntervalKey,
Drop Table tmpBridge;
Drop Field Field From FactTable;
How can we get this data in our fact table.If We require to end up in one table.