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!
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.