Regarding file content conversion in Sender File channel

[Former Member]

Hi all,

In one of my requirement, one file contains several details records as given below,

101,india,1001,albert,517193

101,india,1002,hilbert,517193

101,india,1003,robert,517193

102,nepal,1004,kiran,9234334

102,nepal,1008,kiran,9234334

102,nepal,1003,kiran,9234334

103,nepal,1004,kiran,9234334

103,nepal,1008,kiran,9234334

103,nepal,1003,kiran,9234334

i want to send all the records which starts with 101 to one function module and all records which starts with 102 to another function module and all records which start with 103 to some other function module. In my sender channel i am planning to use

101, 102, 103 as key field values to read them into 3 different structures.

like Recordsset structure = detail1,, detail2,,detail3,*.

Details1.keyfieldvalue = 101

Details2.keyfieldvalue = 102

Details3.keyfieldvalue = 103

.

.

.

Will this idea work out??

Thanks,

Balu

[Former Member · Accepted solution]

Hi Balu,

Yes u r correct, u can access the records by setting the key field value as u mentioned.

But other way is also by,

access the all records as similar one, so no key field value.

the whole record as a single element.In the mapping u have a string function called StartsWith.

In mapping u can specify if the incoming record starts with 101 then map it to FM1(Fumction Module 1).

If the record starts with 102 map it to FM2......

This will be very simpler i feel...

If i am nt clear pl do post the problem in detail.

Babu

[Former Member]

I did it by Keyfield name and keyfield value

thanks,

balu