Skip to Main Content
Forums

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!

Mapping Blanks and NULL fields in DataManagement

Alex1Jul 26 2017 — edited Jul 26 2017

Hello experts,

I have to create a data load mapping and I have a issue with a field that is NULL (No spaces).

My file has tab separator and second column could be empty. I add an image to better understanding.

pastedImage_0.png

In this snapshot there isn't any space. So in second line of data is NULL value (no space).

If I add this mapping not work:

pastedImage_1.png

Also I try to apply a #sql using Like expression, but neither works...

pastedImage_2.png

Is possible to fix this issue?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2017
Added on Jul 26 2017
#business-intelligence-applications, #financial-data-management, #performance-management-applications
1 comment
1,828 views