You can translate the question and the replies:

Adding field in flatten view with file name as value

I am creating a flatten view on top of the base view of JSON Data Source. I want a new field to be added in the output within which the field contains file name( ex:- name.json) as value.
user
04-06-2018 06:10:37 -0400

1 Answer

Hi, You can use the Denodo FileSystem Custom Wrapper from Denodo Support Site, utilize the power of [Interpolation Variables](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/path_types_in_virtual_dataport/path_types_in_virtual_dataport#paths-and-other-values-with-interpolation-variables) to obtain the filename and assign it to the output field. Alternatively, if you do not have access to Denodo Support site for downloading FileSystem Custom Wrapper, you can develop your own [custom wrapper](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/generating_wrappers_and_data_sources/creating_wrappers/custom_wrappers) to retrieve the filename information. You can also refer to the related Q&A [CSV Filename Column](https://community.denodo.com/answers/question/details?questionId=9060g0000004EgmAAE&title=CSV+Filename+Column) to get more details. Hope this helps.
Denodo Team
05-06-2018 05:41:41 -0400
You must sign in to add an answer. If you do not have an account, you can register here