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.
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.