This content has been marked as final. Show 2 replies
I am trying to use the IntervalMatch function to create a Bridge table for my Slowly changing dimensions, like in this example.
However, it keeps telling me "Field not found" for the interval match. If I remove the interval match and just load the table, it will run, but for some reason it will not load the interval match.
Does anyone know why this would happen?
Here is my code.
LOAD ABC_PartNumber as PartID,
Date#(FromDate) as FromDate,
Date#(ToDate) as ToDate,
ABC_PartNumber &'|'& FromDate &'|'& ToDate as KEY_PartID_Interval //BridgeKey
ABC_PartNumber as TmpPartID,
ABC_PartNumber &'|'& QC_DATE as KEY_PartID_CountDate //BridgeKey
Where QC_Count <> 0
IntervalMatch(QC_DATE,TempPartID) // THIS IS THE LINE THAT KEEPS FAILING
PartID as TmpPartID