"not equal to" operator, and looking for duplicates

Technical support

Moderators: Bob Cergol, Data Access, Cintac

"not equal to" operator, and looking for duplicates

Postby rrr » Sun Jul 14, 2013 4:14 pm

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
rrr
 
Posts: 4
Joined: Sun Jul 14, 2013 9:13 am
Location: Aarhus, Denmark

Re: "not equal to" operator, and looking for duplicates

Postby admin » Thu Aug 29, 2013 3:07 pm

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
User avatar
admin
Certified Dynamic AI Professional
 
Posts: 177
Joined: Thu Jan 01, 1970 1:00 am
Location: Copenhagen, Denmark

Re: "not equal to" operator, and looking for duplicates

Postby Bob Cergol » Thu Aug 29, 2013 4:14 pm

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
OutputDupes_1.png (24.97 KiB) Viewed 3778 times

OutputDupes_2.png
OutputDupes_2.png (26.73 KiB) Viewed 3778 times


Regards,
Bob
User avatar
Bob Cergol
Certified Dynamic AI Professional
 
Posts: 359
Joined: Fri Dec 11, 2009 5:48 pm

Re: "not equal to" operator, and looking for duplicates

Postby rrr » Fri Aug 30, 2013 6:53 am

Hi Bo and Bob. Thanks for your help. Its exactly what I was looking for, thanks!
rrr
 
Posts: 4
Joined: Sun Jul 14, 2013 9:13 am
Location: Aarhus, Denmark


Return to Technical Support

cron