Page 1 of 1
Incorrect Record Count with Lookup
Posted: Wed Oct 07, 2009 12:33 pm
by emeri1md
I am using a lookup to join two datasets. When using the lookup, I get an incorrect record count along the reference link. I should be seeing 448, the actual number of records. Instead I get 2838, which is the number of records from the main link (which displays the correct value).
Is this a known issue? Does it affect how my lookup functions?
Thanks,
Matt
Posted: Wed Oct 07, 2009 1:07 pm
by Sreenivasulu
Is it in the display on in the director logs. The data on the director would be correct
In the display it would be incorrect at times.
Regards
Sreeni
Posted: Wed Oct 07, 2009 9:36 pm
by siauchun84
Did you put any setting like reject the unmatch records in your lookup stage?
Posted: Wed Oct 07, 2009 10:16 pm
by Kryt0n
That threw me first time I started using 8x. Haven't quite figured out what it is reporting... maybe the number of successful lookups although I'm sure I have hit a few times where that doesn't seem true... I've pretty much learnt to ignore it anyway