Hi,
I need some help. I am trying to create a qvd to displays call metrics. This takes in 2 spreadsheets from disparate sources. One of the spreadsheets does not have the closed date populated so I am using an If(IsNull etc.. to populate with todays date. No problems on that bit.
I then need to calculate the number of days between start and finish and for this I use the Ceil function num(date) - num(date) etc. No problems with this either.
I then add a banding field (pretty standard if days between etc). This banding also exists in the very first load as well.
My problem is that on reload I get duplicates not from the data where I have calculated dates date but from the clean data in the first load. This does not occur for every record. I also know that it is from this data source because the data in the Call No is different, in on e table the cals start PHD and in the second INC
Script posted below
My duplicate data looks like
Call No Days Days Band
1 4 0-5 Days
1 - 0-5 Days
Any help gratefully appreciated
