How to Split file into unique records

[Former Member]

Hi All,

I have an requirement..to spilt the file into unique records based on HD & TR(i will explain below with example about HD and TR) segments. i have two records in Flat file i need to split the file into two files here HD to TR lines is one record how can i achive this one with out using BPM.

HDP123045992595 3045992595 125162263500 5162263500

CIMABC02 11BH0393188 HIP PHARMACY SERVICES

CDN400378353093 33.550000 5.290000 -1.000000

CIMABC02 11BS9531624 SENIOR CARE PHARMACY - STATES

CDN400378180701 19.700000 10.400000 -9.000000

CIMABC02 11BN7027798 GELOS POINT PHARMACY

CDN400378004501 7.690000 4.600000 -1.000000

CDN400378004501 7.690000 4.600000 -1.000000

CIMABC02 11FU0529896 ULTRA CARE PHARMACY

CDN400378348201 185.150000 98.900000 -11.00000

CIMABC02 11AM1590606 M & I PHARMACY

CDN400378347530 314.450000 162.300000 -1.000000

CDN400378349501 213.600000 132.750000 -1.000000

TR-362.990000 1

HDP123045992595 3045992595 125162263500 5162263500 3

CIMABC02 11BH0393188 HIP PHARMACY SERVICES

CDN400378353093 33.550000 5.290000 -1.000000

CIMABC02 11BS9531624 SENIOR CARE PHARMACY - STATESB

CDN400378180701 19.700000 10.400000 -1.000000

CIMABC02 11BN7027798 GELOS POINT PHARMACY

CDN400378004501 7.690000 4.600000 -1.000000

CDN400378004501 7.690000 4.600000 -1.000000

CIMABC02 11FU0529896 ULTRA CARE PHARMACY

CDN400378348201 185.150000 98.900000 -1.000000

CIMABC02 11AM1590606 M & I PHARMACY

CDN400378347530 314.450000 162.300000 -1.000000

CDN400378349501 213.600000 132.750000 -1.000000

TR-362.990000 1

[Former Member]

Hi...

Make Source message cardinality as 1 and Target message cardinality as 0...unbounded.

Map the Source HD---splitbyValue--Target Field.

Source TR---SplitbyVlauew-Target Field.

Regards,

Leela

[Former Member]

Hi

My understanding for your requirement is you wanted to create separate file for every HD to TR values. Right ?

This doest require BPM

Read the file in FCC sender,

use multi mapping

pass this data to the target. For all HD to TR values it will pass the data and create separate files

Check this blog

/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible

For your requirement you need to map Root node of source to Message 1. This will allow multiple files generated for each HD to TR values.

Thanks

Gaurav

[Former Member]

- create the sender adapter (FCC)

- mapping to create the target message (multi-mapping ) 0..unbounded

- receiver adapter (FTP) for multiple MI created