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

Delimited file source headers have _0 appended to them
answered 18-10-2021 09:16:58 -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: 2

Delimited file data source Delimited File DENODO Delimited Files

Delimited File sources with DateRange
answered 02-11-2020 03:49:16 -0500

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

Interpolation Variables Delimited Files

Write the retrieved data into multiple files
answered 04-05-2020 05:23:54 -0400

Hello, Need to retrive the data from Oracle database, it may have millions for records, I need to write the data in to muliteple CSV files(split the data in to mulitple files). I was able to read the data and write it as single files using schedule adm...

Answers: 1

Denodo scheduler admin Delimited Files

Error while creating Base View with Delimited Files
answered 20-02-2020 06:59:27 -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: 11

Delimited Files

GENERATE_VQL_TO_CREATE_<json>_BASE_VIEW()
answered 07-02-2020 20:22:19 -0500

Hey, There is a stored procedure to generate vql to create base view for jdbc sources - GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW() but is there a option i can generate vql for otehr datasource. I.e json, csv, custom, etc

Answers: 1

Create Base View JSON Delimited Files

Delimited File Error
answered 14-01-2020 07:10:08 -0500

Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...

Answers: 1

Base view 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