cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert Rows in to Column

Former Member
0 Kudos

Hi Gurus,

I have two record for one person in the data base with different description. But i want to display this information in Single Row in the Report in WEBI like EMP NO Desription1 Description2 like that. I am using XIR3.1

Any Suggestions

Thanks

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

BO_Member

Does you have EmpNo, Descr1 & Descr2 as objects defined @Universe??

YES, Drag them to Vertical Table(by default), which BO creates after hitting run query. Align objects how you want to display.

NO, Create Variables where applicable and follow the same.

I'm Back

Former Member
0 Kudos

Hi,

Yes this is a good idea, generate a universe schema there most be have relation between two tables. the relation you know forign key and primary key relation according to there relationship. so create the universe with one to one codrinolity equie(eno--->eno) join and drag the three object(eno, discription 1, discription 2) and export universe.

but,

the database table most be like:

emp table:

eno(primary key__________ename

01______________________praveen

discription table:

disc no__________discripition__________eno

01______________discription 1_________ 01

02______________discription 2_________ 01

All the best.

Former Member
0 Kudos

Hi,

You can build a Cross tab report in webI. Then You can solve your Problem.

Regards,

Narendra.

Former Member
0 Kudos

Choose a table from Templates Tab. It could be the pivot-like table. Then drag and drop person name in the blue cell shown at left, and drag and drop the description dimension in the white cell.

You'll see that users name doesn't repeat, and description 1 and description 2 are shown one beside the other.

Now, to place the title you have to write the word Description in the blue cell that appears above. SInce you want it to say Description 1 and description 2, you'll have to play with column functions. I don't remmeber well, but for titles you could use this formula:

="Description "+ColumnNumber()