Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to remove extra spaces from file generated from BIP report
I have tried unchecking , still generating these characters in the front for each row.
Answers
-
Hello Ramani,
Is the snippet you shared from the XML file or the output file when scheduling the report?
Thank you
Hassan0 -
Output file
0 -
Welcome to Oracle Analytics Community.
Can you share a screen shot from output to show how it looks? Normally this will be a template issue rather than a DM issue. Please check your template once.
Thanks.
0 -
Hi Mandeep,
Agreed, it's just template. It was working fine before and I just made one small change and upload again. I have removed few elseif's. that's the only change I did.
If TermDate IS NOT NULL and Asg_Action <> ‘GLB_TRANSFER’
Then
If Termination_Reason = 'ADMIN' Then 'ADM'
Else If Termination_Reason = 'ATTENDANCE' Then 'ATT'
Else If Termination_Reason = 'FAILED_DRUGS' Then 'FDT'
Else If Termination_Reason = 'LAYOFF' Then 'LAY'
Else If Termination_Reason = 'MISCONDUCT' Then 'CON'
Else If Termination_Reason = 'UNSATIS_PERF' Then 'UNS'
end if
0 -
Try the below:
Suppress Blank Lines with <?if:condition?>...<?end if?>
Use inline formatting like:<?if:FIELD!=''?><?FIELD?><?end if?>
Check the below:
0 -
Hi Ryaz,
Thank you for the suggestion, the template has lot of if statements, when I applied to the one I made changes it didn't work. I have done modification to the original one again very carefully and it worked this time in development and crossing fingers it will work in Production.
1 -
Thanks for the update. So, possibly the issue was due to incorrect update of the template.
0 -
If my response has answered your question or assisted you with your concern, please click"yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for
0
