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"
<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!
@Raj Praveen Can you please check the below link: