N:1 File to File Scenario..

[Former Member]

Hi Experts,

I am trying to do N:1 file to file scenario. Input source directory contains 5 files and each file consists of many of records and i want all the entries in input files need to be transformed to single ouput file.

Example:

Input files

-

---

File1 : ABC

File2 : DEF

File3 : EFG

File4 : HFG

Output file:

-

---

File0: ABC

DEF

EFG

HFG

How we can achive this?

Regards,

Srini

[dharamveer_gaur2]

Hi

doing a N:1 mapping, you need a BPM. This is possible only with a transformation step.Without BPM it's not possible.Use BPM collect pattern to collect your multiple file into one file.

N:1 Mapping this blog help u

look BpmPatternCollectMerge

//part1

//part2

[Former Member]

Hi Ara.

You need to do multimapping.

As said above go to Message mapping. -> messages tab and then add number of messeges you want in source side.

It will show as

Messages 
  Message1
  Message2
  .
  .
  Message5

If the requirement is to merge fields into 1 field or something. You can use standard function or UDF

Thanks

Gaurav

[Former Member]

Do multi mapping...Go to Messages tab in Message Mapping. Add the message type in the Source Message. Probably develop the UDF for the desired result