Detect csv file formt

[sharmilaj]

Hi,

I have a bunch of text documents which is read as csv in Alteryx. 

The csv is formatted both in ANSI and UTF-8.

I need a way to detect each file in the path on whether it is ANSI or UTF-8. If so i want to maintain a similar kind of files maintain UTF-8. 

Is there a way in Alteryx to detect and then change the file format. ?

Thanks!

[caltang]

You can see that information via XML:

From there, you can fetch the code and compare it against the table at the bottom of this page: https://help.alteryx.com/20231/designer/code-pages

This is the best way I know of.