File-based Integration unexpected behavior

Hello everyone,

We are using File-based integration to load data from a file to PBCS.

However, we meet unexpected behaviors.

We created a file with two rows for testing; one row has data, and one row has 0 value:

After running the integration (Replace - Replace), we used ad hoc to check. But the data showed only 0.

When we kept the file, we only had one row -14242323.45 —> It showed properly.

As far as I know, the data should show -14242323.45.

I don't know what was wrong here.

How can I fix it? Or this data file should have a unique combination ?