SFTP File routing having multiple set of data

[hsonnenahalli]

Dear Experts-

I am working on a scenario in which need to retrive a ZIP file and unzip the same and post the data to HANA. It sounds simple but the thing is with the file itself. The way the data is structure has multiple data in a single file as shown below in example file. Each row has an identifier like ABC, EFIJ etc. If you see the file it does not have any header details. So taught if I can use a router then I can route the file to different messages and then load load the data to HANA. Please find the attachment of my integration flow. I am unzipping the file and then trying to route the message using router. But am not what am missing it is not working. If you can take a look at the scenario and provide some taught to resolve this issue it would be really appreciated.

ABC|V&B|IC& Beverage|20180808000000000|20180808100121729|20180808|100122|

EFIJ|V&B|IC& Beverage|20180808000000000|20180808100121729|20180808|100122|

JJJJJ|V&B|IC& Beverage|20180808000000000|20180808100121729|20180808|100122|

Router Configuration

I have choose Non- XML as it is a pipe delimited data. ${header.SenderID} contains 'ABC' but no luck. I have tried find the solution but most of them have mentioned about XML.

router.png

Please let me know how I can get specific data from PIPE delimited file.

Regards

HS

[hsonnenahalli]

I think i figured it out. I have used a Content Modifier and declared an header and then routing in which have an non-xml expression as $(header.SenderID) Contains 'ABC' and in the same mentioned the ABC as CSV file identifer in CSV to XML converter. This allowed to me the get the data which was required.

I have a follow up question. I was able to get one set of data using router in which one was the default but when tried to get multiple header data using router it is not working meaning adding 3rd routing. Please let me know if you have any taught. Please find the screenshot my existing configuration.

Thanks for the help as always.

Regards

HS

[hsonnenahalli]

Sri-

Hope all is well. I need to split the data and route it to different mappings. For example, I need to split the ABC data and route it to a mapping using ABC as a header.

ABC|V&B|IC& Beverage|20180808000000000|20180808100121729|20180808|100122|

Hope am clear.

Thanks

HS

[Sriprasadsbhat]

Hello Hari,

Its not clear from your query whether you want to route the above file having 3 line items based on the first field of the line ( i.e ABC ). Or your fill will contain multiple lines and you want to split them and then route it to multiple senders.?

Regards,

Sriprasad Shivaram Bhat