โ11-23-2020 05:17 AM
Expression for Conversation.Text = $[โ$ConversationPost.Textโ].toString().split(โ|โ).map((elem, index) => [elem])
Mapper Output:
The desired output is:
โConversationPostโ : {
โTextโ: โcomment #2 US142โ,
โTextโ: โcomment #1 US142โ,
โArtifactโ : โ/hierarchicalrequirement/โฆโ
}
Not sure where did I go wrong.
Is there any possible way to achieve this output?
Solved! Go to Solution.
โ11-23-2020 08:43 AM
Please find the attached simple pipeline:
SL_Community_1_2020_11_23.slp (5.0 KB)
Hope that the output from this pipeline, that I have attached is what you are trying to achieve.
Regards,
Spiro Taleski
โ11-23-2020 08:43 AM
Please find the attached simple pipeline:
SL_Community_1_2020_11_23.slp (5.0 KB)
Hope that the output from this pipeline, that I have attached is what you are trying to achieve.
Regards,
Spiro Taleski
โ11-23-2020 09:10 AM
The map() function returns a list of values, the value you are returning, [elem]
from the map call, is a list as well. So the resulting value will always be a list of lists with this expression. Also, I noticed your data has duplicate keys. Using the same key will override the previous value stored at that key text
, so I would recommend using the unique keys like given in the example by @Spiro_Taleski