I have json file as below, Need help to read below data and load into CSV file,it doesn't fetch all the columns but only the first row
tfileinputJson component i used
Do you have any specific logic for extra columns in target table? If yes you can implement that logic in tmap and connec new attributes to target.
That means you are using incorrect json structure or while importing json defined it as wrongly.
If possible can you please share complete json structure you are using as source?
Please show us the details of your Loop Json query and Json mappings from your tfileinputjson in a screenshot or text.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables