SFTP Flat File Scenario in HCI

[itsravi]

Hi All

We have challenge while converting the flat file (pipe separated )with multiple line items to XML structure in HCI using "csv to xml converter ".

We have generated a XSD structure in CPI and then using this XSD with CSV converted.

For the easy understanding we are attaching the xsd we have used and the Sample flat file used.

Sample payload :

WMARLAPT|RIDGID|D5825B6||R2601|CS17334N658493|0|2018-03-14||2018-10-12|2018-10-23|Cassandra|Brown|770-433-8211||0.00|||Replaced bearing.|DAVID|THEISINGER|4619 W 89TH ST||HOMETOWN|IL|60456|US|7086365704|test@testL.NET|110117|089037008172|1|089037008172|||641587001|1|641587001||||0|||||0|||||0|||

Where as the line items from the payloadsample-payload.txt

1)641587001|1|641587001||

2)||0|

3)||||0

4)|||||

5)0|||

sample-payload.txt

sample-sourcexsd.txt

Hi experts need you some inputs to achieve this business scenario

Thanks

Ravi