Transform 4 level structure to CSV

[Former Member]

Target Message (receiver)

Root

--Tag (1..1)

-

---

Field1

-

---

Field2

-

---

Field3

--Line(0..n)

-

---

Item(0..n)

-

---

Field1

-

---

Field2

-

---

Field3

Given my structure above, how can I transform this into CSV? I've researched that FileContentConversion can only cater to 3 levels. Mine has 4 levels.

Any suggestion?

[Former Member]

Hi,

1.

Root

--Tag (1..1)

-

---

Field1

-

---

Field2

-

---

Field3

--Line(0..n)

-

---

Item(0..n)

-

---

Field1

-

---

Field2

-

---

Field3

For this structure, u can have FCC.

This structure i think can be treated as 3 level , instead of 4 levels.

The Item(0..n) is a node not a element... which is under Line(0..n).. gain a node.

So , the structure is same as

Root

--Tag (1..1)

-

---

Field1

-

---

Field2

-

---

Field3

-

---

Item(0..n)

-

---

Field1

-

---

Field2

-

---

Field3

I think there is no difference it will impact in mapping or any where.

2. go with Java mapping, and access all the rows as a single element. And based on contents u can recognise them.

U will have a lot of control on the data. So the mapping will become easy.

I hope this wil solve ur prblm.

If prblm still exist, pl do post.

Babu

[rajasekhar_reddy14]

USE XSLT Mapping,and select output method as text in Mapping program.

Regards,

Raj

[jose_augastine3]

Hi,

Refer this

/people/karthiknarayan.kesavan2/blog/2007/08/22/file-content-conversion-for-multi-hierarchical-structure

Hope this helps !!!

Regards,

J Augastine