Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 250 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 92 Oracle Analytics Trainings
- 16 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