Flat file Conversion

[dharamveer_gaur2]

i All,

I am designing an scenario : Flat file to Proxy

I have comma separated source flat file contains header and item(File contains around 5000 records).

There is no key value in the file

first 2 value are part of header and rest items

Sample file format :

11,22,XX,YY,CC

11,22,TT,RR,FF

66,44,PP,JJ,MM

88,66,SS,WW,LL

88,66,SG,WG,LG

88,66,ZS,SW,ML

Now target value should be in structure like

Header (occurance 1)

- Number1

- Number2

Item (0..unbound)

-TextFiled1

-TextFiled2

-TextFiled3

Result look like :

11,22

-

---

XX,YY,CC

-

---

TT,RR,FF

66,44

-

---

PP,JJ,MM

88,66

-

---

SS,WW,LL

-

---

SG,WG,LG

-

---

ZS,SW,ML

Kindly suggest approach for this specific File content conversion

Thanks,

Dharamveer

[Former Member · Accepted solution]

Hi Dharamveer,

It would not be possible without Keyfield. Their should be an identification for the header and the lineitems.

Ref: /people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

Thanks,

[dharamveer_gaur2 · Accepted solution]

Thanks for reply, same i was thinking not possible without key...but looking if any work around possible.

[Former Member · Accepted solution]

As per my knowledge, it would not be possible to do so.

Thanks,

[baskar_gopalakrishnan2]

Keyfield is certainly required to distinguish records between Header and Items.

Recordset Structure: Header,1, Items, *

Reference Links:

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file