unique function....

[eyetry]

Not understanding the results when I'm using the unique function... Sometimes it seems to work right others it seems wrong...

creating an f_map with a rule like

EXTRACT_SUBSCRIBER_ROW(Row:In1, COUNT(UNIQUE( DEP_BEGIN_DATEep_Row:In1 )))

Sometimes the count is right others it is off... ie.. I have two dependents with the same date value. the 'count(unique...' value = 2. other times for other dependents they have the same value and count = 1.

What am I missing.

 

[OllyC]

I think the rule might be too complicated for Mercator - it'll lose track of what its trying to count when you also include the functional map.

I would create another temporary output card where you duplicate the input but add an extra field to count the unique dependent rows.

Olly.

 

[janhes]

The question is is it the unique function or the count function that is giving the wrong result? If it is the unique function you need to look closely at the data in a hex editor.

 

[SeriesConsumer]

What version are you using? I remember a problem with UNIQUE in 6.7.1. Furthermore COUNT(UNIQUE(...)) might not be the best idea as both are series consuming functions.

 

[eyetry]

Resolved. I was pointing to the wrong card.