to create multiple files on the receiver side based on key field

[Former Member]

Hi Gurus,

My scenario is File to File

My Source structure is as below

My File looks like

My file looks like below

570774 11/26/2008 8:12 6296 xxxxxxx 985-399-5157 1153 Teche Road Morgan City United States Lori Eisenman Louisiana 70380 0 1153 Teche Road Morgan City United States Lori Eisenman Louisiana 70380 303 101400100000 3365440332522 ELLE YVES SAINT LAURENT Eau de Parfum Spray 2 61 78 156 184 184 0

570774 11/26/2008 8:12 6296 xxxxxxx 985-399-5157 1153 Teche Road Morgan City United States Lori Eisenman Louisiana 70380 1153 Teche Road Morgan City United States Lori Eisenman Louisiana 70380 376 106074700JP0 3365440347229 GOLDEN GLOSS N° 27Shimmering Lip Gloss 1 28 28 28 0

570775 11/26/2008 8:15 6296 xxxxxxx 985-399-5157 1153 Teche Road Morgan City United States Lori Eisenman Louisiana 70380 7 1153 Teche Road Morgan City United States Lori Eisenman Louisiana 70380 284 9000400000 3365440316546 L'HOMME Eau de Toilette Spray 1 53 53 53 60 60 0

for each new order number(key field ex: 570774) a new xml file to be created , from the above example 2 xml files sholud be created(one for 570774 and the other for 570775)

How can i acheive this functionality?

Please help me on this, Thanks in advance

Regards

Srinivas

[Former Member]

Hi Srinivas,

map the key field to the parent record of the target field. Use the split by value and change the source key field level to higher one so that the all occurences of the key field are occuring. The mapping will be like this;

Source Key Field (change to higher level) --> Spli by value --> Filename creation UDF --> Target header field.

Try this.

Regards,

Murugavel.

[Former Member]

Make your Target msg 1:n. Based on your OrderNumber field/node, create a new Target XML msg.

ie. Map your OrderNumber to Target XML node. (Test it by viewing the Queues)

You have to take care of the other field contexts accordingly.

-SM