Hi everyone,
I’m currently facing an issue with Excel migration where empty values from the Excel sheet are overwriting existing data in our IFS application. Specifically, I want to prevent fields from being updated with empty values. For example, if the “DUNS No” field (column F) is empty, I don’t want it to overwrite the existing value in the application.
Here’s a simplified example to illustrate the problem:
Example Data:
| ID | Name | Address | City | Country | DUNS No |
|---|---|---|---|---|---|
| 1 | Company A | 123 Street | Kraków | Poland | 123456 |
| 2 | Company B | 456 Avenue | Warsaw | Poland | |
| 3 | Company C | 789 Boulevard | Gdańsk | Poland | 789012 |
In this example, for row 2, I want to update the application with the data from columns B-E for the corresponding ID, but leave the “DUNS No” field unchanged if it is empty, regardless of whether data exists in this field in the application or not.
Has anyone encountered a similar issue or have any suggestions on how to handle this in the migration process?
Thanks in advance for your help!