Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Not able to replace Null string to blank in BIP for teradata query
3323115
Rank 2 - Community Beginner
Summary
Not able to replace Null string to blank in BIP for teradata query
Content
Hi ,
In the BI Publisher parameter, for Teradata query, I need to replace NULL character string with blank space
I tried oreplace, but its failing.
erm.empl_full_name in oreplace(:pvar_officer1),'NULL','')
But data model is failing to lead. The requirement is when NULL string is coming for erm.empl_full_name, it should replace by blank & run the query
0
Answers
-
please post query then will provide you better one as per business rules. Thanks
0