Connector Improvement: Workday Financial Management Purchase Supplier Item and Supplier Table Join Results in Zero Purchase Items Mapped to a Supplier
Answered
Fix data populating PURCHASE_SUPPLIER_ITEM and SUPPLIER tables so that they can be joined resulting with a non-zero row count. The ERD appears to have the intent in its design to allow purchase_items to be mapped to a supplier. The IDs between these two tables should have at least some matches and the fact that the join results in 0 rows indicates either the source data IDs are incorrect in one (or both) table or the result of the fivetran extraction is incorrect. We have requested the client verify their IDs are correct.
related to support ticket: Id #265527
-
Official comment
Hi Bryan,
Are you seeing data in only one of the tables or both? I verified on my instance that the data is populating and joining as expected. I would reach out to Workday support to verify why you are unable to join the data.
Frank
-
Yes, there is data in both tables (the supplier id fields contain guid values). The two queries below both return 0 records (the second one is my attempt at a workaround).
SELECT *
FROM shca_source_Data.workday_financial_management_shc.purchase_supplier_item psi
INNER JOIN shca_source_data.workday_financial_management_shc.supplier s
ON psi.supplier_id = s.id
SELECT *
FROM shca_source_Data.workday_financial_management_shc.purchase_supplier_item psi
INNER JOIN shca_source_data.workday_financial_management_shc.supplier_item si
ON psi.supplier_item_id = si.id
INNER JOIN shca_source_data.workday_financial_management_shc.supplier s
ON si.supplier_id = s.id
-
Hi Bryan,
I checked your first query on our test instance and saw that we were getting matches on all records in our tables. Are you seeing any values in for supplier_id in your purchase_supplier_item table?
Frank
Please sign in to leave a comment.
Comments
3 comments