cancel
Showing results for 
Search instead for 
Did you mean: 

multiple files, same structure into one message without BPM

Former Member
0 Kudos

Hi,

Is it possible to read multiple files (each with single row) as one message without BPM by some configuration in channel?

For example:

input files placed simultaneously in input folder:

file1: a,b,c

file2: f,g,h

file3: k,l,m

after adapter picks files, xml message:

<Message_type>

<RecordSet>

<file>

<A>a</A>

<B>b</B>

<C>c</C>

</file>

<file>

<A>f</A>

<B>g</B>

<C>h</C>

</file>

<file>

<A>k</A>

<B>l</B>

<C>m</C>

</file>

</RecordSet>

</Message_type>

?

Accepted Solutions (0)

Answers (3)

Answers (3)

justin_santhanam
Active Contributor
0 Kudos

James,

I'm not understanding the reqmt. Do u want to merge all the three files to gether? Could you please shed some more info on the reqmt?

raj.

VijayKonam
Active Contributor
0 Kudos

If you read each file separately, each one becomes a separate message in XI. If you want to merge them in to single file, BPM is the only way.

Each file would be a separate message in XI. But in your scenario, there is no cut off condition up to what time, it has to merge the files..!!

VJ

Former Member
0 Kudos

Bond,

Yes Bond. You can read the pattern what you have given.

First Read the whole line in the file as one record. Now take the substring or write udf in mapping. This entirely depends upon your requirement.

Regards,

---Satish

Former Member
0 Kudos

If the files has same number of columns or similar structure then try to give in the sender file adapter, the file name as' .' (with out quotes). If they are of same extension use *.xml or *.txt etc... . Can you again the post the target structure you want, the one you posted is little confusing