File - PI - Multiple files design requirement -Urgent

[former_member645464]

Hello Expert's,

                   We have a scenario where in We receive a file from a source system. PI will pick up the text file .The goal is to take all the records in that file and split up them into multiple files based on the GL entity (for example: Avilla,CWC)- Each split file will be sent to a different destination systems.some records in file could also go via email to some systems.

My source file will looks like below..

India  04549218008     Avilla      KT52AVILLA              01      ELECTRIC   03202013-04182013INR+1438.21  

India 04549218008         Avilla    KT52AVILLA               01s     MOTOR     03202013-04182013USD+100.67

India 04549218008        Avilla    KT52AVILLA        01         induction    03202013-04182013USD+80.67

US    100000157873      CWC   KT03CWC      01      ELECTRIC    03202013-04182013INR+1438.21 

US   100000157873      CWC    KT03CWC     01s     MOTOR       03192013-04172013USD+25.36

US   100000157873      CWC   KT03CWC      01       induction     3172013-04172013USD+71.41

Germany  111390060700  Bell   BL13FORT    02        GAS  03012013-03312013USD+1892.31

Germany  111390060700   Bell   BL13FORT   02S      PIPE  03012013-03312013USD+1992.31

UK       11872397           Gulf        SY02NEW    01       ELECTRIC   3062013-04042013USD+39880.25

UK      11872397           Gulf        SY02NEW     01L       MOTOR    3062013-04042013USD+39880.25

India    12345678          Avilla       KT52AVILLA    02      MOTOR     3202013-04182013INR+1438.21

From the above file, i need to filter "Avilla" and send 1st 3records and last record as total 4 records need to send target System A .In the same way, based on condition either CWC or bell or Gulf etc need to be send to target System B,target System C etc.

Kindly suggest us best suitable solution (without ccBPM or ccBPM)/Mutimapping or etc.

Regards

shiva

Regards

[former_member181985]

Hi,

Use mutli-mapping concept. No need of BPM.

Regards,

Praveen Gujjeti

[allamudi_loordh]

Hi Sree,

Go for udf to get each GL into one unique record (0.unbound) ..then create different communication channel unconditionally to work.. give those FCC parameters by considering particular records.

MT--

GL_ Avilla (0..un)

fields

GL_CWC(0..un)

fields.

etc.

just create CC by considering only GL_avialla alone..

next CC for CWC alone..

try this way..

Regards,

Loordh.