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” } ...
  • cstewart's avatar
    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)