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!

Load Non-numeric data to a target file in DataManagement

3244971Sep 6 2018 — edited Sep 10 2018

Hi All,

I have a requirement in datamanagement where both my source and target are files. The source files is tweaked to get the target file. The data column can have data in numeric as well as non-numeric (Eg,12345,123456A,124578B etc). Now I have a mapping where all the numeric data is to be loaded as numeric and all the non-numeric data's last character(text) has mapping as below:

               Source value          Target value

                      *A                         100

                      *B                          200

                        *                              *

If I load a file, only numeric records are imported to the workbench and the non-numeric records are being skipped. I could not select the Load Method property in the Target Application as my target is a File(Custom Application). Please let me know how this can be achieved in DM.

Thanks in Advance.
This post has been answered by JohnGoodwin on Sep 6 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2018
Added on Sep 6 2018
#business-intelligence-applications, #financial-data-management, #performance-management-applications
5 comments
501 views