以下是代码示例:
输入数据源: [ { "id": 1, "name": "John", "hobbies": ["reading", "hiking", "swimming"] }, { "id": 2, "name": "Mary", "hobbies": ["dancing", "painting"] } ]
数据流程转换活动中的'Select”转换: { "firstName": "$.name", "hobbies": "$.hobbies" }
数据流程转换活动中的'Derived Column”活动,使用以下代码'hobbies”字段转换为字符串: concat(join(hobbies, ","))
最终输出数据源: [ { "firstName": "John", "hobbies": "reading,hiking,swimming" }, { "firstName": "Mary", "hobbies": "dancing,painting" } ]