Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DM in PBCS - Missing rows with NULL value in CSV File

Alex1Aug 31 2020 — edited Sep 3 2020

Hello experts,

I try to load a csv with several records and I have the accounts in columns (multicolumn). When the first account column has a value, I see the records correctly in the DataLoadWorkbench:

pastedImage_10.png

On the other hand, if the first column of Account has a missing value, I don't see the rest of Accounts in DataLoadWorkbench.

CSV screenshot:

pastedImage_0.png

One solution is to force a 0 in the first Account if there is no value (red cell), but I cannot use this solution because my customer provide this type of file and I can't modify.

What kind of Mapping could I do to fix this issue?

Regards

This post has been answered by ArjunBhasin on Jun 23 2023
Jump to Answer
Comments