Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

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

ArthurL
5 - Atom

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 !

1 REPLY 1
Trifacta_Alumni
Alteryx Alumni (Retired)

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