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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

PBCS - Data Exchange File Load skip row when column value is null

I need a hint when loading a file with Data Exchange, we need to skip the line when an attribute column is null.

Tried many options like using SQL in the Target Expression, conditional in Source Expression, but no success.

My file load has 4 attribute columns and I use them to later map members with SQL expressions. But I would need to skip lines where one of these columns has no values, and that's the tricky part. This is a delimited file load.

Any suggestions?

Thanks!

Comments

SiatGesi Feb 14 2025

THE FIRST problem howto wrap I have resolved…

SiatGesi Feb 14 2025

now I'm trying to move the unzipped files (pictures) from db to AS… my real problem… best regards

1 - 2

Post Details

Added on Jan 23 2025
1 comment
60 views