英文:
Nifi - Separate the column in two colums (Array)
问题
I can help you with the translation part. Here's the translation of the provided text:
我有一个 JSON：{"consultor_do_projeto": ["Iago de Oliveira","Murilo Tavares"]}我需要转换成：{"consultor0" : "Iago de Oliveira","consultor1" : "Murilo Tavares"}在 Jolt 规范中，我可以这样做吗？如果第三项存在，它将是 `consultor2`感谢您的帮助！
英文:
I have a JSON :
{"consultor_do_projeto": ["Iago de Oliveira","Murilo Tavares"]}
I need to transform in:
{"consultor0" : "Iago de Oliveira","consultor1" : "Murilo Tavares"}
In Jolt Spec, Can I do this?
if the third item exists, it will be the consultor2
Thanks to help!
答案1
得分: 3
是的，您可以通过使用Jolt规范来实现，例如：
[{"operation": "shift","spec": {"*_do_projeto": {"*": {"@": "&(2,1)"}}}}]
其中：
- &(2,1) 从上面的2级中提取第1个星号的替换内容（例如，子字符串 "consultor"）
以及
- & 旁边的内容提取了与 @ 符号对应的索引值（
0,1,..）的数组中的值。
网站http://jolt-demo.appspot.com/上的演示如下：
英文:
Yes, you can do through use of a Jolt spec such as
[{"operation": "shift","spec": {"*_do_projeto": {"*": {"@": "&(2,1)&"}}}}]
where
- &(2,1) brings the 1st asterisk replacement from the 2 levels up (eg. the substring "consultor")
and
- & next to that brings the counterpart value for @ sign which refers the indexes (
0,1,..) of the array.
the demo on the site http://jolt-demo.appspot.com/ is
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论