Q&A BY TAG 'Delimited Files'

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

Error while creating Base View with Delimited Files
answered 02-12-2019 07:41:44 -0500

I'm trying to create a Base View with the information detailed in DEN60EDU0112LAB01 and everything works fine until I select the Create Base View, it gives me an error: "There was an error while creating this base view: Column names could not be genera...

Answers: 7

Delimited Files

Delimited File sources with DateRange
answered 18-06-2019 07:58:32 -0400

Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...

Answers: 4

Interpolation Variables Delimited Files

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

source file info
answered 07-08-2018 15:14:16 -0400

Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_sto...

Answers: 3

Excel XML Delimited Files

Delimited File: vertical tab and form feed as column and line delimiter, how do I put those characters into denodo?
answered 09-02-2018 00:56:39 -0500

Hi, I have a file with vertical tabs as column delimiters and form feeds as line delimiters. In Denodo, I'm trying to input the vertical tab into the column delmiter box, and it seems to work okay for the column delimiter. (I go to my source file, hi...

Answers: 3

Delimited Files delimited_files tuple

Error while creating Base View (incorrect expression)
answered 28-12-2017 03:55:34 -0500

Hi: When attempting to create a base view from a Delimited File, there is an error displayed for the regular expression ^. However this expression is used in the example. Can you please help me? I attach an image with the error https://imgur.com/a/s9Rc8

Answers: 1

Delimited Files delimited_files tuple

OAuth 2.0 support for Delimited files
answered 12-12-2017 05:12:53 -0500

I want to retrieve a delimited file from a protected data source. The datasource is using OAuth 2.0 for authentication. The delimited file http transport does not support OAuth 2.0 for authentication. Can I get around this or enable it for Delimited fi...

Answers: 1

Delimited Files oauth

Data Sources - Combining Multiple Flat Files
answered 28-11-2017 06:46:05 -0500

A Data Source pushes data in CSV format into a Local machine. EveryMonth a Folder is generated with the file set. Each folder has aroun 150 files. Example Folder Name : DS_Jan17 Files : Account, customer, Products etc Folder Name : DS_Feb17 Files : Acc...

Answers: 1

File data source Data Source CSV Mulitple Files Delimited Files

File Generation
answered 22-11-2017 08:09:14 -0500

I need to publish a Flat and XML file to Unix server. I have already created views as required. Is it possible to create a job to publish data in an given external location ?

Answers: 1

XML Delimited Files

How to define multiple columns delimiters in denodo vdp Delimited File
answered 14-10-2015 07:41:58 -0400

Hi I want to know if its possible to define multiple columns delimiters while editing a DF datasource. The problem is than the file usually is delimited by ";" but sometimes it comes delimited by a ",". I read documentation and didnt find this issue.

Answers: 1

vdp Delimited Files