Remove Duplicate from Results

Epicor ERP 10
1

This should be an easy one.
In a job, we have a list of JobAsmbl.PartNum.
image

I have created a BAQ that gives me the list if it contains ‘/Q’.
This has worked OK.
However, I need help to remove duplicate occurrences.

Here is what I get:
Q84951, Q91665, Q91665, Q91665, Q63427, Q85373, Q91665, Q91665

Here is what I need:
Q84951, Q91665, Q63427, Q85373

Here is an extract from the query phrase…

image
image.png1555×405 37.4 KB

Your help would be much appreciated!

Thanks,
Himal

2

Use the Group By check boxes or, more simply, on the subquery tab use the drop down for “Distinct”.

3

Hi Jason,
Thanks for the suggestions.
This worked:
on the subquery tab use the drop down for “Distinct”

Cheers,
Himal