Pass File name to JSON Extract

Support/help with CloverETL (4.9) and CloverDX (5.0 or newer) implementation problems

Posts: 11
Joined: Mon Dec 23, 2013 6:28 am

Pass File name to JSON Extract

Postby bhavinultimate » Mon Jan 04, 2016 9:31 am


I have list of txt file (json format) in hdfs reading from universal data reader and passing to JSON Extract.
Reason for reading first in universal data reader is there are some bad records files which i am discarding and only json format file i am passing through JSON Exract ie port:$0.Field1:discrete

when reading through universal data reader i have figured out the way to get file name by setting up auto filling option in metadata
However i am not able to JSON extract and i dont want to change my json file format i just want to add one more column in my metadata where i can have file name.


Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: Pass File name to JSON Extract

Postby slechtaj » Tue Jan 05, 2016 6:09 pm

Hi Bhavin,

You mentioned you are not able to extract the data from the JSON, but could you please describe this little bit more (what you are getting and what you need to get)? The best would be if you could share the graph (with all related files) and the execution log with us.
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at

How to speed up communication with CloverCARE support