Drawing BOM table - NO DUPLICATES - different parameters

Hello,

I have to join in an assembly components which were retrieved from different databases (so different user parameters)

I have multiple parameters for description:

-DESCRIPTION_1

-DESCRIPTION1

-DESCRIPTION

Some have parameters for PART NUMBER and some does not:

-those which have have a parameter PART_NUMBER

-the others I choose the name of the model (NAME)

When I try to join the BOM, I've created relations in the repetitive region:

BOMDESC - for description

BOMPN - for part_number

The issue is that THE BOM somehow is not taking out the same descriptions

FOR EXAMPLE:

I have two hoses:

1st model is called 500_01.prt

has DESCRIPTION1 = "HOSE"

has PN = "500"

2nd model is called 500_02.prt

has DESCRIPTION_1 = "HOSE"

has PN = "500"

Somehow the BOM table does not identify those as the same component so it will appear two lines

ITEM DESCRIPTION PN QTY

1 HOSE 500 1

2 HOSE 500 1

instead of

ITEM DESCRIPTION PN QTY

1 HOSE 500 2