create complex json - twriteJSONFiled

Anonymous — Thu, 11 Aug 2016 20:08:07 GMT

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]

Re: create complex json - twriteJSONFiled

Anonymous — Wed, 17 Aug 2016 07:25:59 GMT

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

Best regards
Sabrina

topic create complex json - twriteJSONFiled in Talend Studio

create complex json - twriteJSONFiled

Re: create complex json - twriteJSONFiled