Duplicates causing wrong count

[Krish2459_58]

Hi,

In the below image one case ID "WO-00000852" has two Actions numbers "JOB-00000929" and "JOB-00000930".

Actual data is like for action number the supllier is

"JOB-00000929"  : Aspect Furniture Systems

"JOB-00000930" : Alexander Construction

But in the below table both the suppliers are assigned to both Action numbers which causing wrong count when selecting a supplier.

Supplier is an extenal table which is joined as

Urb_TEMP:
LOAD

wo_id,
ActionNumber,
Job_Priority as Priority,
trim(UrbaniseID_SUPP) as UrbaniseID_SUPP
.
.
.
.
etc (Many fields);,

from XYZ;

left join(Urb_TEMP)
Load
trim(UrbaniseID) as UrbaniseID_SUPP,

trim(F_ContactSupplier_SEQ) as F_ContactSupplier_SEQ_Temp

From supplier(qvd);

Please help to solve this

[rwunderlich]

Do not join the Supplier table. Keep it as a separate table. 

Supplier:
Load
  trim(UrbaniseID) as UrbaniseID_SUPP,
  trim(F_ContactSupplier_SEQ) as F_ContactSupplier_SEQ_Temp
From supplier(qvd);

-Rob

[Krish2459_58]

Hi,

Here is my model. I want to bring Supplier to Urb_TEMP table.

Suppliers:
LOAD
F_ContactSupplier_SEQ ,

UrbaniseID as UrbaniseID_SUPP,
"Supplier Name"

FROM [$(varTQVDPath)Suppliers_Temp.qvd]
(qvd);

Urb_TEMP:
LOAD

wo_id,
ActionNumber,
Job_Priority as Priority,
trim(UrbaniseID_SUPP) as UrbaniseID_SUPP,
etc... (Many fields);

from XYZ;

[MayilVahanan]

Hi

One UrbaniseID_SUPP has 2 supplier name? 

[Krish2459_58]

Hi,

One WO_id has two action numbers and supplier table is linked by UrbaniseID_SUPP like below.