on 03-04-2008 3:18 AM
hi,
in file to file scenario,how to differnitated the header and item when keyvalue is not specified separatetly.
i have flat file like
ord100 1000 10 00
mat1 10 kg
mat2 20 pc
mat3 30 lb
ord200 1000 10 00
mat1 20 pc
mat4 40 kg
first three letters of ord100 (order no) should be identified as keyvalue.similarly with mat1,mat2..
pls help on this.
advance thanks
ravi
Hi,
Take ORD as the key for the Header data and MAT as the itemdata.
check some links on FCC parameters.
File content conversion sites
/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1
/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file
/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter
/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1
/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2
/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30
/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file
/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter
/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns
/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem
/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter
/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion
http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm
Regards,
Phani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hhmmm
Is it an fixed length file?
then you can use ORD and MAT as identifier....
if ORD100 is single value then read this in 2 field and concatenate it in mapping.....with this it will be easy...to read
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ravi
Key field and the value is snecessary to identiy the recordset strucutre like HEADER and ITEM if you dnt have the keyfiled and its value you cannot places the specific record in header and ITEM you have....
in your case you need to use
ORD
MAT as keyfiled but these are coming with differenet values which makes it difficult to read as it is....
else you need to read the whole row one field and take care in UDF or write an Module which will append the Kayfield agaisnt HEADER row or ITEM row....
if leaagacy is feeding file to XI then ask legacy to add the kayfield value ahead of each row to identoy it as header amd item
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
you have to identify key as first 3 letters that is ord for header & mat for data.
any further questiions
do ask me
Regards
Sheetal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.