Skip to Content
0
Former Member
Sep 05, 2012 at 05:56 AM

Split flatfile into multiple messages without a BPM?

10 Views

Hi.

I'm getting a flatfile into PI and will be able to identify a keyrow based on a value lets call it "x".

Each time I find the row starting with "x" then I want to create a new message and being able to send it to a specific detsination.

All rows bellow the "x" row and until the next "x" row should be in the message.

example:

File payload:

xabcdefghiklmnopqrstuvwxyz

rabcdefghiklmnopqrstuvwxyz

sabcdefghiklmnopqrstuvwxyz

tabcdefghiklmnopqrstuvwxyz

xzyxwvutsrqponmlkihgfedcba

rzyxwvutsrqponmlkihgfedcba

szyxwvutsrqponmlkihgfedcba

tzyxwvutsrqponmlkihgfedcba

Result:

Message 1 based on:

xabcdefghiklmnopqrstuvwxyz

rabcdefghiklmnopqrstuvwxyz

sabcdefghiklmnopqrstuvwxyz

tabcdefghiklmnopqrstuvwxyz

Message 2 based on:

xzyxwvutsrqponmlkihgfedcba

rzyxwvutsrqponmlkihgfedcba

szyxwvutsrqponmlkihgfedcba

tzyxwvutsrqponmlkihgfedcba

Message 1 and 2 has to be able to be routed to different destinations.

How should I solve this without a BPM?

BR

Kalle