Skip to main content

Hi All,

 

I am facing a strange issue.

My requirement is - read a file(CSV formatted file) from AWS S3 location , change delimiter to ";" to "," and write it into S3.

 

scenario 1: If the input file with header and data, I am able to change delimiter and uploaded into s3 successfully.

scenario 2: if input file with only header and no data. I am unable to change delimiter.

 

I tried lot of ways but no luck.

I have attached file format below (input_process.flat)

 

input file format like below:

"PROCESSID";"COT_ID";"LIS_LBL";"TOTAL_LIST"

 

Unable to read headers with no Data 

<file:read doc:name="read_input_process.flat" doc:id="7b982532-3c91-4b9c-a65e-6355b927a0b8" config-ref="File_Config" path="C:\Users\rajPraveen\Desktop\rp\testing\input_process.flat"/>

<ee:transform doc:name="Transform Message" doc:id="736cf6c9-47b1-4245-9480-32a7541929e2" >

<ee:message >

</ee:message>

<ee:variables >

<ee:set-variable variableName="varCSV1" ><![CDATA[%dw 2.0

output application/java

---

read(payload, "application/csv",{separator: ";"})]]></ee:set-variable>

</ee:variables>

</ee:transform>

 

I am facing issue with scenario 2.

 

Can anyone help me?

 

Thanks!

1 Antwort