Set null when no match found - Different Behaviour

  • 61Views
  • Last Post 21 September 2020
  • Topic Is Solved
0
votes
Jay Ong posted this 11 September 2020

Hi Skyvia Support,

I have started using the New Runtime Environment with my Import Package using UPSERT. I select 'Set null when no match found'. Previously I saw 0's appear in the files I download from the History Details when there is a new unique record added to the same file using the Old Runtime Environment, but now I only see the record ID number if I import the same file with new records.

Is this by design with the new runtime environment?

It was handy to see the records with the 0 entry for the ID in the file as I could pinpoint which were the new records. The UPSERT function appears to work, so nothing is actually broken, but I would like to understand the behaviour. 

 

--- Extract from your documents ---

Set null when no match found

This check box determines what to do when there is no match in the lookup object for the provided lookup key column values.

If this check box is not selected, the imported row fails. If this check box is selected, a Null value is assigned to the mapped column.

For the UPSERT operation, if you map an ID or primary key column via the lookup mapping, you should select this check box. In this case, when no match is found, a Null value is returned, and the INSERT operation is performed; otherwise, an UPDATE operation is performed. But if this check box is not selected, the row simply fails when no match is found.

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 13 September 2020

Hello Jay,

 

Unfortunately, we cannot reproduce such a difference between old and new runtime. In both cases, the log file includes ID values of the processed records (inserted or updated). Can you please specify the name/id of your package so that we are able to check it.

 

Looking forward to your reply.

 

Best regards,

Mariia

 

 

0
votes
Jay Ong posted this 21 September 2020

Hi Mariia,

 

Please close this ticket. I will have an opportunity to setup another Import in a couple of weeks and I will re-test and record the name.id and report back if I observe the same behaviour.


Kind regards

Jay

0
votes
Mariia Zaharova posted this 21 September 2020

Hello Jay,

 

 

Thank you for your reply.

If you encounter any further issues, please feel free to contact us.

 

Best regards,

Mariia

Close