Home / Q&A / Creating Base View using Delimited files
You can translate the question and the replies:

Creating Base View using Delimited files

Hi Team, I have one requirement: There is one folder on FTP path which contains text files(many text files) having record like Name:Neetu Age:34 Department:IT ContactDetails: Mob:123456 Phone:56778 Address:xyz EducationDetail: HighestQualification:MCA College:CICME Year of passing:2009 Nationality:India caste:hindu I want to create base view of these files, one for ContactDetail, one for EducationDetails etc.I tried to create base view by giving delimiter as colon(:) Base view is getting created but its taking by default 2 files from the folder(not picking all files) and also data source are getting created with three filed only like path,coloumn0, coloumn 1. It is not showing whole coloumn name so that I can create flatten view by right click on coloumn.Not getting column name to create flatten view Please help here. Thanks in advance
Delimited file data source
user
20-10-2020 03:13:37 -0400

1 Answer

Hi, I could create a base view from all the files in a folder and the column name can be also shown by checking the Header and setting the column delimiter with multiple characters dependent on the data source structure. You could find more information in the section [Delimited File Sources](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources) of Virtual DataPort Administration Guide. Also, if you have a valid support account, I would suggest raising a support case on the [Support Site](https://support.denodo.com/cases/) for more detailed help with the issue. Hope this helps!
Denodo Team
20-10-2020 10:39:04 -0400
You must sign in to add an answer. If you do not have an account, you can register here