I am trying to work through an issue with an SFTP File Processing Workflow.
We are trying to grab the data from the SFTP from our Shopify Customer Orders. In doing so I keep encountering errors in the Insert/Update step & I am not sure where the disconnect is.
The Error is:
PGS-220000 PostgreSQL error: ERROR: column w0.morderlineitemkey does not exist LINE 1: ...N CusShopify C1 ON (C1.sOrderlineitemkey = substr(W0.mOrderL... ^ HINT: Perhaps you meant to reference the column "w0.sorderlineitemkey".
Does anyone have an idea what this could be?
Check if you column orderlineitemkey exists and then the format. It's looking for a text value.