tWriteJson field output not working

[root]

I have some input data which I need to get converted to a json object. I am half-way there, but, cannot pin-point what to do to get it fully working. Any help is appreciated.

Original OP: 

abc;pqr;123
def;ghj;876

Expected JSON Object:

{
   "test_op":[
      {
         "lname":"abc",
         "fname":"pqr",
         "score":"123"
      },
      {
         "lname":"def",
         "fname":"ghj",
         "score":"876"
      }
   ]
}

[root]

Shameless bump. I am unable to find a way to get the expected JSON output using tWriteJsonField. Any suggestion on how to mark an item as "Group"? Any other alternatives to creating a json object?

Thanks.

[Anonymous]

Hello,

Sorry for delay.

We will check your attachment test_json.zip file and then come back to you as soon as we can.

Thanks for your time.

Best regards

Sabrina

[fab_74]

hi,

what is your expected JSON output? (Structure).

Have an input and output example?

[fab_74 · Accepted solution]

hello,

can you look that corresponds to your expectation?(example3)

twritejsonfile.zip

[root]

Thank you so much. Example 3 worked for me. I am still baffled on why we need that "field1" value to be included in the grouping option (input and output). Other than that, it worked flawlessly. Thank you so much.