blocks|key|135545|text|用这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|135546|'"'%2BToString([_CurrentField_])%2B'"'|code-block|syntax|javascript|135547|然后，在写入CSV时，将输出图标中的分隔符更改为\0：|offset|length|style|CODE|135548|​|135549|📷|atomic|135550|135551|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/783da78a6d55a9af7f02dcbf4d389d8f.png|imageAlt^0|0|0|O|2|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|13|8|@$I|14|J|15|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|16|8|@]|9|@]|A|$]]|$1|O|3|P|5|Q|7|17|8|@]|9|@$I|18|J|19|1|1A]]|A|$]]|$1|R|3|N|5|6|7|1B|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z|10|-4]]]]

Use this:
<pre><code>'&quot;'+ToString([_CurrentField_])+'&quot;'
</code></pre>
And then, when writing to the CSV, change the delimiter to <code>\0</code> in the output icon:
<img src="https://i.stack.imgur.com/Rk8qu.png" alt="Delimiter in Write To File CSV" />

blocks|key|264663|text|解决了。有两个可能的解决方案，一个Alteryx侧和一个Synapse侧。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|264664|Alteryx+side：最新版本2.2.0支持设置CSV分隔符，可以从以下链接https://community.alteryx.com/t5/Public-Community-Gallery/Azure-Data-Lake-Tools/ta-p/852262下载|ordered-list-item|offset|length|style|BOLD|264665|Synapse+side：在csv中，双引号必须位于包含逗号的字符串字段(默认情况下，Alteryx“”连接器本身就是这样做的)；然后使用以下链接中指示的外部表脚本，确保PolyBase将引号中的数据理解为单个值https://learn.microsoft.com/en-us/answers/questions/118102/polybase-load-csv-file-that-contains-text-column-w.html|264666|entityMap|0|LINK|mutability|MUTABLE|url|https://community.alteryx.com/t5/Public-Community-Gallery/Azure-Data-Lake-Tools/ta-p/852262|1|https://learn.microsoft.com/en-us/answers/questions/118102/polybase-load-csv-file-that-contains-text-column-w.html^0|0|0|C|14|2J|0|0|0|C|2Y|36|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@$E|W|F|X|G|H]]|9|@$E|Y|F|Z|1|10]]|A|$]]|$1|I|3|J|5|D|7|11|8|@$E|12|F|13|G|H]]|9|@$E|14|F|15|1|16]]|A|$]]|$1|K|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]|S|$5|N|O|P|A|$Q|T]]]]

Solved. There are two possible solutions, one Alteryx side and one Synapse side.
<ol>
<li>Alteryx side: the latest version 2.2.0 supports setting the CSV delimiter and can be downloaded at the following link
<a href="https://community.alteryx.com/t5/Public-Community-Gallery/Azure-Data-Lake-Tools/ta-p/852262" rel="nofollow noreferrer">https://community.alteryx.com/t5/Public-Community-Gallery/Azure-Data-Lake-Tools/ta-p/852262</a>
</li>
<li>Synapse side: in the csv double quotes must be on the string fields containing commas (the Alteryx &quot;Azure Data Lake File Output&quot; connector does this by itself by default); then use the external table script indicated in the following link, which ensure PolyBase to understand data inside quotes as an single value
<a href="https://learn.microsoft.com/en-us/answers/questions/118102/polybase-load-csv-file-that-contains-text-column-w.html" rel="nofollow noreferrer">https://learn.microsoft.com/en-us/answers/questions/118102/polybase-load-csv-file-that-contains-text-column-w.html</a>
</li>
</ol>

I need to create a csv file with Alteryx on Azure Datalake Gen2, reading from a table which has a string field that might contain commas. I'm using the &quot;Azure Data Lake File Output&quot; connector in the Alteryx flow (which, as far as I know, does not allow me to choose the csv delimiter)
<a href="https://i.stack.imgur.com/ZCuWU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZCuWU.png" alt="enter image description here" /></a>
Alteryx puts double quotes only on the string fields containing commas (it seems that Alteryx uses commas as separator automatically), but I need Alteryx to put double quotes on all string fields. I tried with a multifield formula
<pre><code>'&quot;' + [_currentfield_] + '&quot;'
</code></pre>
but then the csv has 3 double quotes at the start and end of each string field (this because quotes are special characters).
Is there any way I can solve this? Or alternatively is there a way to define a specific delimiter in the &quot;Azure Data Lake File Output&quot; connector?
The problem arises because starting from the csv file we are going to create an external table in Azure Synapse Analytics using PolyBase. If a string column contains a string with commas, then Synapse recognizes that column as two columns, giving the &quot;too many columns&quot; error.
Thank you very much for helping!

Writing csv with double quotes around strings (Alteryx)

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我需要在Azure Datalake Gen2上创建一个带有Alteryx的csv文件，从一个包含逗号的字符串字段的表中读取。我在Alteryx流中使用"Azure Data“连接器(据我所知，它不允许我选择csv分隔符)​​Alteryx只在包含逗号的字符串字段上放置双引号(似乎Alteryx自动使用逗号分隔符)，但...

问在字符串周围用双引号编写csv (Alteryx)
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在字符串周围用双引号编写csv (Alteryx)EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在字符串周围用双引号编写csv (Alteryx)
EN