on 04-25-2014 10:29 AM
Hi,
We have a BO webi report in that for one column we are dispalying City name and City Code ,Now i want to split that column to one value
Currently the column values are showing as below:
Column Name
--------------------
USBWG; BOWLING GREEN
From backend only we are getting two values in the report
Please let me know wheather we can split that column value to like below
Column name
------------------
USBWG
Many thanks in advance.
Thanks & Regards,
Kumar V
Hi Kumar,
Create a variable as shown below
=substr([Column_name];1;(Pos([Column_name];";"))-1)
or
=Left([Column_name];(Pos([Column_name];";"))-1)
It will Resolve your issue.
Regards,
Anish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
assume you have DImension ABC you try below formula
=Substr([ABC];Pos([ABC];"/")+6;Length([ABC]))
Substr(input string; integer start length; integer length);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just use Left(Trim(<Object Name>);5)
Thanks,
Sakthi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar ,
r u using any formula for merging those two field or its already merged from DB side (City name and City Code).
Thanks
Anurag Srivastava
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kumar,
In your Webi document, right click on Variables in your Available Objects panel. Select create new variable and the syntax will be as Sakthi has added below. Remember your object name goes in square brackets! [CITY]
Use this variable in your table and not the current dimension that t
With regards
Gill
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.