Json Fomat Corrections in Talend

[since_1995]

the input is given through Excel and my Json generated is as below:

{"documents":{"documents":[],"blanket_document":["f0033dc0-126b-40ba-89e0-d3061bdeda4c","1948335f-7dcd-410c-8f90-fc74c9fe5236","Individual_AI_Blanket_Endorsement.pdf"],"policy_document":["f0033dc0-126b-40ba-89e0-d3061bdeda4c","1948335f-7dcd-410c-8f90-fc74c9fe5236",[]],"pl_document":["f0033dc0-126b-40ba-89e0-d3061bdeda4c","1948335f-7dcd-410c-8f90-fc74c9fe5236",[]]}}                    here i don't want to generated the array if there is no pdf document. Is that possible??   

Actually I want it as below

{"documents":{"blanket_document":"f0033dc0-126b-40ba-89e0-d3061bdeda4c/1948335f-7dcd-410c-8f90-fc74c9fe5236/Individual_AI_Blanket_Endorsement.pdf"}}

[marceloveras]

Could u send a sample of your job?  

Seems like you need :

tExtractJSONFields -> tJSONWriteFields (Rewriting your JSON object remapping it)

Best Regards

Marcelo Veras

[since_1995]

jsarray1.PNG