Ok, well ac_registr is not date dependant. So, for one particular value, which relates to a number of utilisation dates, you have each record related to all canonical dates.
I'd suggest that ac_registr is not a good candidate here for your key field. Maybe in combination with utilisation date as a composite key it would be.
To do this:
At the start of your Utilization load change it to this
ac_registr & '_' & UtilizationDate as %KeyACUtil;
LOAD * INLINE [ac_registr, UtilizationDate, daily_cycles,
And change your Datebridge load to this:
ac_registr & '_' & UtilizationDate as %KeyACUtil
,UtilizationDate as CanonicalDate
,'UtilizationDate' as DateType
hi Marcus that seems to work nicely, however this works if there is only one table with ac_registr. Otherwise loops will occur, which is an issue I have. I would have to rename ac_registr to ac_registr1 to prevent loops from happening.
In my full QVW I have 6 tables with ac_registr which all go to the datebridge, is there any way I could work my way arround this?
QlikQuest3.qvw 371.2 K