create complex json - twriteJSONFiled

[Anonymous]

Hi..
I'm having input excel file like this

 pd ;       ID;       code;            value
  1   ;    1000      ;    10          ; 100
  2   ;    1000      ;    20          ; 200


I want my table data in this json format.
  ID
    pd
      code
      value
I've tried using  twriteJSONFiled component
inputexcel----> twriteJSONFiled--->tlogrow

getting like this
{"rootTag":{"ID":{"pd":{"code":"10","value":"100"}}}}


Why am not getting the ID and pd values ?


[color=#393318][size=2][font=Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif]
[/font][/size][/color]

[Anonymous]

Hi,
How did you set your twriteJSONField component? Could you please post your setting screenshot into forum?

Best regards
Sabrina