philliperamos
6 years agoContributor
JSON value split by comma
Hi, I’m trying to split the value “ConfigValue” string in the following JSON :
[
{
PipelineID: 25
PipelineName: “CashValue_Main”
ConfigName:“CashValueDates”
ConfigValue:“1218, 1217”
} ...
- 6 years ago
This is fairly easy, first use a mapper to split your ConfigValue field: $ConfigValue.split(“,”), and then use the JSONSplitter to split out into multiple documents:
I attach an export of the pipeline.
SplitField_2019_09_03.slp (8.1 KB)