How to write count(distinct feild) in data model script level

[#1]

I have two feilds coming from the same table

Table1:

Id,

Purchase Tag,

Asset No

I want to find out the duplicates in Purchase tag.

Ideally for a particular purchase tag only one asset no should be mapped.

If for the same purchase tag, more than one asset no is tagged means, it is a deviation and i need to highlight those issues.

How to highlight those issues???

[sunny_talwar]

May be this:

Table1:

LOAD Id,

          Purchase Tag,

          Asset No

FROM

Join (Table1)

LOAD Purchase Tag,

          Count(Asset No) as CountCheck

Resident Table1

Group By Purchase Tag;