Contet Conversion for multilevel hierarchy structure

[Former Member]

Hi,

I wanted to create csv file as a output for the structure

GROUP1 1-1

ITEM1

ITEM2

GROUP2 1 - unbounded

ITEM3

ITEM4

GROUP3 1-10

ITEM5

ITEM6

but i see only one level content conversion is possible. Does anyone worked such kind of scenario ?

Laks

[former_member187339]

Hi Lakshmi,

Few questions on the structure..Is it like thsi

GROUP1 1-1
-ITEM1
-ITEM2
--GROUP2 1 - unbounded
---ITEM3
---ITEM4
---GROUP3 1-10
-----ITEM5
-----ITEM6

means group3 is withing group2 and so item5 and item6 becomes 4th level in hierarchy

FCC is possible till 3 levels and hence in your case the normal FCC will not work.. I will suggest you to look into this link and do some workaround like that mentioned in the blog

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=%28J2EE3414700%29ID1981012450DB0107297976066050286...

Also You want Group1, Group2 etc to be written in th output file? Then you need to have them in a field of target structure (so possible need to put one more node at each level viz Group1, 2 and 3 which will have the name of the group).

Regards

Suraj

[former_member200962]

but i see only one level content conversion is possible

Did you check this blog: /people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

Regards,

Abhishek.

[Former Member]

Thanks Abhishek,

I already has a look o

n this blog but that is to generate output of each level in new line but i want something like below so that i can see this in excel sheet in proper column.

TARGET CSV file

GROUP1

ITEM1, ITEM2

GROUP2

ITEM31, ITEM41

, ,ITEM511 ,ITEM611

, ,ITEM512, ITEM612

ITEM32, ITEM42

, ,ITEM521 ,ITEM622

, ,ITEM522, ITEM622