Forum Discussion

philliperamos's avatar
philliperamos
Contributor
6 years ago
Solved

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”
}
]

Into a JSON document like this:
{
“YearEnd”: 1218
}
{
“YearEnd”: 1217*
}

What’s the best process that I can use to do this? JSON Splitter or Mapper, or a combination of both?

Any assistance would be greatly appreciated.
Thanks!

  • 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)

2 Replies

  • cstewart's avatar
    cstewart
    Former Employee

    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)