Q&A BY TAG '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
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
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
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
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
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
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
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
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
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