Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 52 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
How to modify the content of a column through a result similar to RPAD
TheoMC
Rank 1 - Community Starter
Summary
How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to have a result similar to RPAD function
Content
Hi,
We want to create a report that will need to have a specific length per column & wish to have a result similar to a RPAD function.
In other words, the length of the column values is determined (for example 30 characters) and the column is filled with the data of the element selected in the analysis + spaces until it reaches 30.
Is this possible through an analysis or a Logical SQL function (OTBI seems to use Logical SQL which doesn't know the RDAP function and therefore doesn't allow us this action until now ...).
best,
Theo
0