Hi,
I have an application on the server that outputs a csv file. When outputting, there's always a prompt to select encoding type. Is there a way for me to default this encoding type to specific selection? I want to default it to unicode UTF-8
Thanks,
Johnny
yes! but it's not intuitive - you need to blob convert to UTF-8. Then blob output as a file with a .csv extension.
I have multiple columns in my file. Do I have to blob convert each column using the configuration below? And then how to I use the blob output tool? I'm not sure how I can export the whole file as .csv.
no. you add a record id transpose and then create a concatenated field of your values using summarize tool separated by your delimiter. Then you convert that field.
I can't remember if blob output downloads automatically but you create a dummy filename like "my.csv" and it isn't much work to add a filebrowse/action tool to that if you need to.
Unfortunately, this does not work for me. I still get a drop down asking me to choose an encoding type.
I believe the best options are:
1.Train users to pick the appropriate encoding type
2. Output to a shared drive with a link to the output location displayed in the result window in Gallery.
@csmith11 That's with a blob conversion and blob output? Can you share a screengrab of your workflow? Can you try changing the extension filename to test.txt and see if you still get that?
txt works just fine.
\\
Works with CSV too, but we might as well just write out to a normal CSV output since the result is the same.
Fortunately, Alteryx has already accepted the idea to default the encoding option.