cancel
Showing results for 
Search instead for 
Did you mean: 

Query on creating datatype

Former Member
0 Kudos
52

Hi Gurujis,

I had a input file seperated by comma with around 30 fields.

How I will create the datatype based on this information in IR?

Even,If if I create,will this will be read by file adapter?

Kindly suggest how I will build datatype with this info?

appreciate if I get links with somescreenshots and the type of adapter to be used.

Regards,

AlexFleming.

Accepted Solutions (1)

Accepted Solutions (1)

santhosh_kumarv
Active Contributor
0 Kudos

Hi,

You need to use File Adapter at the sender side with content conversion to convert the csv file to xml file.

Have a look at this blog

By Venkat Donela

also this wiki [FLAT FILE TO FLAT FILE|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/flatFILETOFLATFILE&]

Thanks

SaNv...

Former Member
0 Kudos

Hi Santhosh,

Link was useful.

But,can you give guidance on when the input file is having more than 50 fields......and is there is no pattern followed.

Example:

Name

Salutation

Education

Flex stephen stanes jone hanes..........

tyer 45 erty tyfmt mt234.........

.......................................

In the above example for all the example data should be read to datatype?If I a not reading all using adapter ,will it throw error?

How to make my adapter make it understand to understand my relevant data starts at 5th line....

For the above given data,can you suggest the datatype to be build in IR?

Regards,

Alex.

santhosh_kumarv
Active Contributor
0 Kudos

>>But,can you give guidance on when the input file is having more than 50 fields......and is there is no pattern followed.

there should be a pattern either the fields should be of a fixed length or a field seperator like comma(,) else you job is going to be difficult..

>>In the above example for all the example data should be read to datatype?

Yes. All the inputs read should be tagged to a datatype..

>>If I a not reading all using adapter ,will it throw error?

You cannot leave few parts of the file unread by the adapter, the adapter will always read the entire file at a time...

>>How to make my adapter make it understand to understand my relevant data starts at 5th line

You can use the keyField to tell that any record that has this keyFiled value belongs to a particular node..

>>For the above given data,can you suggest the datatype to be build in IR?

Definately No.

Gud Luck....!

Thanks

SaNv...

Answers (0)