Need to create a Data type for the following flat file

[Former Member]

Hi all

i do have a FLAT FILE ,

1820000000|

0010|ACK

0020|ACR

0040|ACK

0050|ACR

in which 1820000000 is header separted by pipe and it has only one header

and mulitple item

0010|ACK

0020|ACR

0040|ACK

0050|ACR

any one there to help how to create a data type for this flat file

help me please

Thankingyou

Sridhar

[Former Member · Accepted solution]

Hi Sridhar

I think this should work

DT_Source
      Record
         Header        1,1
         Items           1..unbounded

is 0010 etc are key fields for you?

else you can do simple FCC

Recordset Name Record

Structure Header,1,Items*

Header.Fieldname

and so on

Thanks

Gaurav

[Former Member · Accepted solution]

hi Gaurav Bhargava ,

yes it is key fields and i am going to use FCC only to pick the data, thanks you very much

and i have one querry

hope there is no problem since it has file structure as

1820000000|

0010|ACK

0020|ACR

0040|ACK

0050|ACR

as the header is in first line and the item comes in the second line , where my header is just only one constant , but my item changes since it might contain lot of items

f

[Former Member · Accepted solution]

HI

NO problem with this

Check

Thanks

Gaurav

[Former Member]

Use FCC message protocol for content conversion. Define the RecordSet and fieldnames. Search the sdn for examples..

Datatype..

Root

|_Header (0..1)

|_Item (0..unbounded)

[Former Member]

yes i am confused abt the FCC only, dont know how it will pick my file for this

will you please tell , is it possiable to pick this file

please help me

Thanking you

Sridhar

[Former Member]

FTP adapter will pick based on the filename. It doesn't depend whether you have given XML or Flat file.

[SudhirT]

Hi,

File will be picked up irrespective of the structure , for file pick up, it is the file name which matters not the internal data type structure. And after picking the file you can handle it with FCC.

Thanks!

[Former Member]

Hey Sridhar

Whats the requirement

If you want to read this flat file and do some mapping then you need to do FCC. Provide the file name in your sender comminication channel along with the source path. It will read the file

Go to this link

https://www.sdn.sap.com/irj/scn/wiki?path=/display/xi/step-by-step%252bguides

See Flat file to flat file

I think you need to know these step by step

Thanks

Gaurav