issues with parsing JSON file using talend data mapper

[nivedhitha]

hi everyone,

I have complex JSON files that I have to parse and insert into table and I have been using the talend data mapper for this.

below is a screenshot of a portion of my json

and the result of my parsing is

any null values in the json is being neglected and the next non null value is showed for the null keys.

I would like to bring in the null values and have the values under corresponding keys. also attaching the complete json file.

can someone help please?

thanks in advance

[rriahi]

yes I used Talend Data Mapper.

what is your studiio version?

I think your problem is the output structure you need to define a flat structure related to your CSV schema then you do the corresponding mapping.

I have do that using  Talend Data Mapper

and you can obtain this result (I just used Json to show you the result and I had  only  creat a part from the mapping)