Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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