You can translate the question and the replies:

How to read records with a different number of columns from the same source file?

There is one record with 3 fields or columns in a delimited file and there is another record with 4 fields or columns in the same file. How do I read both of these records in the same base view?
user
11-01-2021 07:18:49 -0500

1 Answer

Hello, I was able to create a base view using a CSV file with similar records as described above. I was able to do this by creating a Delimited file data source in the VDP Admin Tool. The missing field will be displayed as 'Null' or blank. Please refer to the [Delimited File Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources#delimited-file-sources) section of the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
14-01-2021 22:18:02 -0500
You must sign in to add an answer. If you do not have an account, you can register here