Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.2K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
PBCS - Data Management - Mapping Question
Hi,
In PBCS Data Management is it possible to map null field to something? We have nulls coming in from NetSuite for Entity/Dept and would like to map them to 'No Dept'. Been playing around with it and nothing seems to take. The 'Scripts' button is grayed out so I'm thinking I can't use scripts in PBCS Data Management?
I'm going to try and see if the NetSuite person can fix this in the Saved Search, but it seems to me mapping a NULL value to something should be possible.
Thanks for any advice!!
Best Answer
-
You should be able to add a SQL mapping, for example:
Answers
-
Is the data being loaded to the workbench or is it being rejected when loading, you should be able to see in the process logs. If it is being rejected then you might be out of luck.
There is no custom scripting in the import format only SQL scripting is available in mappings.
Cheers
John
-
I can import the data, but it doesn't map to Entity. Both are NULL. Is that what you were asking?
-
You should be able to add a SQL mapping, for example:
-
How do you get to the 'Edit Script' screen? I'm not seeing it.
-
This link is not hot. Does nothing when I try clicking on it.
-
You have to put #SQL into the target value - more info Creating Mapping Scripts
-
OK, this is interesting. When I add this mapping as you stated above.
I still get nothing.. So I tried this and nothing...
-
It could depend if the column is actually null, it could contain something else like a space.
-
John,
We lost ability to bring data in during the Import process as something broke between NetSuite and FDMEE. Once that gets restored, I can test the SQL solution. I'm not ignoring you.
-
Still can't get the data to populate from NetSuite source. Going back and forth with Oracle Support and getting nowhere.
So, I'm pretty confident the SQL solution you provided works as everything you suggests works
Thanks for your help!!!!