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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Unable to read JSON file rows, only 1st row

Hi,
I am new with Talend and currently trying Talend Studio for Cloud and considering to subscribing it very soon.
I am trying to create a new job to read our source Json file. I am using tFileInputJSON - main - tExtractJSONFields - main - tLogRow
the content of the file is:

{"name": "Magas", "countryCode": "643", "country": "Russia", "longitude": 45.01776123046875, "location": "Nazran", "airportIcaoCode": "%u04", "latitude": 43.323814392089844, "timezone": "Asia/Baku", "altitudeFeet": 1060, "_id": "%u0", "landmarkId": 100002446640}
{"name": "Truckee-Tahoe Airport", "countryCode": "840", "country": "United States", "longitude": -120.13956451416016, "location": "Truckee", "airportIcaoCode": "KTRK", "latitude": 39.32004165649414, "timezone": "America/Denver", "altitudeFeet": 5900, "_id": "...", "landmarkId": 100003026478}
{"name": "Moton Field Municipal Airport", "countryCode": "840", "country": "United States", "longitude": -85.6800308227539, "location": "Tuskegee", "airportIcaoCode": "N", "latitude": 32.4605712890625, "timezone": "America/Fort_Wayne", "altitudeFeet": 264, "_id": "06A", "landmarkId": 100003159617}

I could only read the first record instead of all 3? What should I do to make the ETL table to read the whole file?
I have a feeling it is due to no proper naming of the node? But other tools that we are using are able to read the file as it is.
Please advise,

Thanks,
Endy
0683p000009MFrl.png0683p000009MFsY.png0683p000009MFsd.png

Labels (2)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

tFileInputJSON read all file as single JSON, You can use 
tFileInputFullRow -> tExtractJOSNFileds -> 

0683p000009MFoD.png

View solution in original post

2 Replies
vapukov
Master II
Master II

tFileInputJSON read all file as single JSON, You can use 
tFileInputFullRow -> tExtractJOSNFileds -> 

0683p000009MFoD.png
Anonymous
Not applicable
Author

Thanks Vapukov, it's working perfectly.
Setting it to resolved.