Pass File name to JSON Extract

Hi,

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.

Thanks
Bhavin

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.