not able to read json file properly

[rohit1804]

Hi All,

I want to read json file and need to store data in table , I have data like below

"data" : {

"port" : {

"1000" : [

"port 1",

"port 2",

"port 3"

]

}

}

-----------------------------------------------------------------

RESULT I want as below in table format

ID | Port

---------------------------

1000 | Port 1

1000 | Port 2

1000 | Port 3

---------------------------

Please help me to achieve this using Talend component.

[Anonymous]

Your JSON file does not look correct. For a start JSON will start with curly bracket ( "{" ) and it looks like your port data may be incorrect. Is this copied directly from your source (if so, I think that may need looking at) or have you typed it out and maybe made a couple of mistake?