Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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;
Hi
One UrbaniseID_SUPP has 2 supplier name?
Hi,
One WO_id has two action numbers and supplier table is linked by UrbaniseID_SUPP like below.