Forum Discussion

Igor_Bozhinovsk's avatar
Igor_Bozhinovsk
New Contributor III
3 years ago

Check if field inside array has value and route the output

[ { “items”: [ { “test”: " ", “id”: 1 }, { “test”: “test”, “id”: 2 } ] } ] Currently we have an array like this , we need to route the output from the Router based on the ...
  • GV2019's avatar
    GV2019
    New Contributor II
    6 years ago
    Copy LinkReport

    eval did not work for me
    I solved it by adding a mapper in front of oracle-execute and mapped parameters to mapper output and used the mapper output in the sql and it worked
    My new select statement is
    “select * from obia1." + $tableName + " partition (” + $partName + “) where rownum < 11”
    $tableName and $partName are outputs from mapper