In my process the map output has been send to SFTP server with filename as "test.csv" use set propertiesshape . But if i directly save the document from process reporting/ from SFTP server, if any of the field value contains some characters it causing issue for example :
offers â€˜max trialâ€™ but it should be offers ‘max trial’
\nâ€¢ visibility of key but it should be \n• visibility of key
â€œno touchâ€ but it should be “no touch”
E-payrollâ€ but it should be E-payroll”
TaxÂ \nTo but it should be Tax \nTo
Reform â€“ W2 but it should be Reform – W2
etc.,. I had to open the file then save it as a CSV in order to have correct values. PFB screenshot for the flat file profile option.
Kindly help me how to resolve the issue.