Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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