"not equal to" operator, and looking for duplicates

[rrr]

Hi everyone

I'm pretty new to Dynamic AI. My company has been using it for a couple of years now. I've spent a lot of time the past weeks discovering the functions and possibilities by going through our existing reports.

1) Forgive me if I've simply overlooked it. How can I in the Filter section filter for a keyword on an exclude basis. I.e. an operator in the != style. I want to exclude rows containing a specific string. Any ideas?

2 When creating a report, is it possible to return only rows where a field, a specific column in this case, is a duplicate of another row?

Thanks so much for any input!

Br,
Robert

[admin]

Hi Robert,

Sorry for the long wait. Your post was not published for some reason.

If it's a free text entry filter, you can use <, > or <>

such as
<>5
<>Joe
12-31-2012

you can also type
in (3,6,9) and
not it (2,4,6)

There may be more ways to accomplish the 2nd task:
you can define a free where statement in the conditions tab of the report.
If you put
Column1=column2, you will only see rows where the 2 values are the same.

Best regards
Bo

[Bob Cergol]

Robert,

To output only duplicates you could:

a) make a grouping on the column you want to test for duplicates
b) make a filter and use the "count" function -- yes Dynamic AI will let you do that but it requires a grouping and the filter will only apply at the first group level.

Examples below illustrate using Adventure Works 2008 Data Warehouse database and the dimGeography table. I grouped on PostalCode. I'm looking for postal codes with at least 3 "duplicates". By making a count type filter I can then show only those groupers where the count is greater than # -- in your case that would be greater than 1.

OutputDupes_1.png (24.97 KiB) Viewed 27327 times

OutputDupes_2.png (26.73 KiB) Viewed 27327 times

Regards,
Bob

[rrr]

Hi Bo and Bob. Thanks for your help. Its exactly what I was looking for, thanks!