
I have a json output shown below. I'm using parsejson to handle the input with output as follows:
I then handle that output as follows:
When the "Wells_to_be_tested" item is processed it creates (in this case) two rows in the resultant table one with duplicated information in fields except "Wells_to_be_tested"
QUESTION: How can I process the json to only have one row with concatenated values for "Wells_to_be_tested"?
Thanks for your time
Hello @AdamW00d
Assuming that your Submission Data is the array of Wells to be tested. Use an expression to join the array items together. Then you should not need to loop through the Submission Data.
Does the above help?
Kind regards, John