Skip to Main Content

Oracle Database Discussions

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!

Data management - conditional column concatenation

Darshan JadhavAug 10 2023

Hello Team,

I am trying to concatenate two columns in Data management.
Our target application is FCCS

For example -
In Import foramat, I am able to concatenate as “Account-CostCenter” But whenever there is no cost center present it comes like “Account-”

Is there any way to ignore "-" if there is no cost center present?

Thank you in advance.

Comments
Post Details
Added on Aug 10 2023
0 comments
202 views