I'd like to know if it's possible to convert encoding in Trifacta.

[ArthurL]

Hello,

I've a CSV file with UTF-16 LE BOM encoding.

I import it in Trifacta and I select X-UTF-16LE-BOM encoding.

All seems ok. I create an empty recipe and an output.

By this output, I want to create a table in BigQuery.

It's ok when I select Trifacta Photon as running environment, but when I select Dataflow + BigQuery, the table created in BigQuery doesn't have the good format.

All the datas are in the last column...

Do you know how to do to change the encoding of my file in a recipe in Trifacta ?

Thank you !

[Trifacta_Alumni]

Hi @Arthur Le Maux?,

All output files are written in UTF-8 encoding per the doc here. Is Photon a realistic option for this job? If not: have you tried different input encodings, e.g., UTF-16LE or simply UTF-16? (Another idea: try MERGEing the columns explicitly and then SPLITting them in the recipe?)

Cheers,

Nathanael