on 2010 Dec 22 12:31 PM
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
Request clarification before answering.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
59 | |
10 | |
8 | |
8 | |
6 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.