Q&A BY TAG 'Delimited file data source'

You must sign in to ask a question. If you do not have an account, you can register here

Delimited file data source, start at specific line
answered 05-11-2021 07:25:16 -0400

I am using DENODO VDP version 6.0 20170925. I want to create a demilited file data source, but my file contains comments in the first 6 lines, each comment marked with the character #. Is it possible to start reading the file only after the comments? T...

Answers: 3

Delimited file data source

Delimited file source headers have _0 appended to them
answered 26-10-2021 00:59:30 -0400

Sorry, I tried to find an answer by searching but couldn't. I have a .csv data source where every column is enclosed in double quotes. When I create a base view off of this source the quotes are removed, which is great, but the header gets a "_0" appe...

Answers: 3

Delimited file data source Delimited File DENODO Delimited Files

Is it possible to create data source in one format and save the view in different format (say parquet)
answered 09-12-2020 23:45:51 -0500

Hi, I have created a data source using ADLS2 container using csv format. Using that I have created a base view. Is it possible to save the base view is parquet format after the view is created in ADLS2.0?

Answers: 1

Delimited file data source parquet file Export Azure Data Lake Storage Gen2

Creating Base View using Delimited files
answered 20-10-2020 10:39:04 -0400

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:...

Answers: 1

Delimited file data source

Date Range parameter doesn't accept date
answered 10-02-2020 05:50:58 -0500

Hi, I am doing the denodo on demand training. One chapter has this excersize 'DEN70EDUD1102LAB02 - Create a Delimited File data source using DateRange function" The file saved in my local directory as below 20160101 20160102 20160103 20160104 2016010...

Answers: 1

Delimited file data source Create Base View delimited file sources rows columns pattern tupple

multiple files Data Source with different columns
answered 11-10-2018 02:50:24 -0400

Dear Community, I have a case where multiple files represent a data source. On each file, the columns that I'm interested for my base view are present, but the files do not have the same column order. Because of this and selecting to ignore errors, w...

Answers: 1

Delimited file data source Delimited Files

Merging CSV Files With Delta Files Dumped Into A SFTP Server Daily.
answered 10-10-2018 11:57:16 -0400

Hey, I am using VDP v7.0 with the latest upated tools and server. I have a use case where we have an SFTP server acting as a data source for us, which has CSVs dumped into it by another system which creates reports for us. For our initial load, we wil...

Answers: 1

Delimited file data source CSV update

denodo installation folder location
answered 24-09-2018 10:18:34 -0400

we try to create a datasource to open denodo logfiles as a source within denodo, but not all denodo installations are in the same folders. Does denodo have any variable we can use in the configuration of this datasource to have the location of the inst...

Answers: 1

Delimited file data source variable

Tuple pattern for delimited file multiline
answered 30-03-2018 19:58:15 -0400

Hi Denodo Team, I have a delimited file with the below data format. In DVP, i would like to create a delimited file data source in tabular format. I have looked at the example given in the thread "Extract from Delimited File" from 2015 but could not g...

Answers: 1

Delimited file data source delimited_files tuple