Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit1804
Contributor III
Contributor III

not able to read json file properly

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.

Labels (3)
1 Reply
Anonymous
Not applicable

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?