Change Encoding

[Alvarom1]

Hi,

I have issues with the characters when importing from from .txt file.

When it is a single file that I use is fine, I go into Query Settings / Applied Steps and I have the option to change the encoding (65001 is the one that solves my issue) at CSV import

But when I import from a folder, several .txt files, I do not have that option (CSV import) in the Query Steps.

Any idea on how to do that?

thanks

Alvaro

[Anonymous]

Hi @Alvarom1,

If you get data from the folder, it will use similar configures to get data from all folder items. I'd like to suggest you write a custom function to iterate all files in folder with CSV connector and combine transformed files.

If you confused about coding formula, can you please share some dummy data for test?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng