Getting error in Render tool

[SCK]

Hi all, I am getting the below snipped error in Render tool. Can anyone tell me why and how to mitigate it please? Thanks for the help.

[Luke_C]

Hi @SCK 

Do you have any special characters in your data? See below link (different app, but same error) with a little more background. It seems like the render tool uses UTF-8 and some data disagrees with that. If you find the offending data try using a 'DecomposeUnicodeForMatch' formula or cleaning it some other way.

https://knowledge.informatica.com/s/article/109584?language=en_US

[SCK]

Where do I find the 'Encoding' option in '.xlsx. file format? I can't seem to resolve it. Please help

[Luke_C]

Hi @SCK 

Unfortunately I'm not familiar enough with the render tool's functionality. At first glance I don't see a way to change the encoding, but maybe others have some thoughts.

[SCK]

Thanks, Luke. Can anybody else help me please.

[Paulteryx]

What file type are you atttempting to render to?

[SCK]

I am trying to output .xlsx type

[echuong1]

Are you able to upload a copy of your workflow and inputs? This would be helpful when trying to find a solution.