Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
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;