Transpose a table without measures

[shyam_uthaman]

Hi All,

I have a table in the below form:

OBJNR	EMPID	CODE
100	20	A
100	20	B
100	20	C
200	30	A
200	30	C
300	40	B

I need to have a view which outputs data in the form below:

OBJID	A	B	C
100	20	20	20
200	30	?	30
300	?	40	?

None of these fields are measures.All are attributes.

Please let me know of your suggestions on the best way to achieve this.

Thanks,

Shyam

[former_member182114 · Accepted solution]

Hi Shyam,

Look for term "pivot" on SCN search, this was already discussed.

Google

Regards, Fernando Da Rós

[shyam_uthaman · Accepted solution]

Found it .. Thanks.

[former_member226419 · Accepted solution]

Hi Shyam,

Glad you solved it. just a small question, Are the columns fixed or dynamic?

BR

Sumeet

[shyam_uthaman · Accepted solution]

They were static.. wonder how a dynamic case would work..