Forum Discussion

Alvarom1's avatar
Alvarom1
Helper I
6 years ago

Change Encoding

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

1 Reply

Replies have been turned off for this discussion
  • Anonymous's avatar
    Anonymous
    Not applicable

    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