Q&A BY TAG 'CSV'

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

Floating points not recognized correctly
answered 20-06-2019 08:47:15 -0400

Hi guys, I'm working with VDP 7.0 and I have this CSV file that amongst other airport-related data contains latitude and longitude information. Here's a sample row of the dataset so you don't have to download the whole file: 34,"Castlegar/West Koote...

Answers: 3

CSV data types Data Type Conversion locale

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

Create a Comma Seperated List (CSV) as part of query resultsL
answered 28-08-2018 03:55:24 -0400

Is it possible to convert a list of values into a csv string as part of query result? Ex: Customer | Item John | Glove John | Bat Desired output: Customer | Items John | Glove, Bat In SQL Server, i would use syntax like shown in this article. https:...

Answers: 1

VQL CSV

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Answers: 1

Excel XML CSV XML Data Source JSON

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

CSV Filename Column
answered 08-09-2017 10:12:02 -0400

I am curious if there is any way to include the filename or part of a filename for CSV files in the base view; something simlar to how the Excel wrapper can provide the sheetname as a column in the base view for an Excel data source. My use case scen...

Answers: 2

CSV

Scheduler Administration Tool CSV exporter
answered 11-04-2017 05:15:20 -0400

Hi everyone! Im currently using Denodo Express to test different functionalities. One of the functionalities is exportng a CSV file about changes in the underlying databases for my base views. I created a "database changes" view in the VDP by using st...

Answers: 1

Job scheduler CSV

specifying custom i18n on scheduler extractor for csv
answered 11-11-2016 08:16:02 -0500

I have specified a custom i18n and am trying to apply this to an extractor btu so far have been unsuccessful. I have tried the following. Setting the i18n on the base view Setting the i18n on the final view Specifying the i18n during the query in the...

Answers: 1

date scheduler csv export i18n

Forcing scheduled extracts to enclose all values in double quotes.
answered 09-11-2016 12:50:28 -0500

I am looking to provide a like for like file extract as a proof of concept, and the extract the users currently have enclose all the column values in double quotes. When I extract as csv using the scheduler (using denodo express 6.0), only values wher...

Answers: 1

scheduler denodo 6.0 denodo express csv formatting

Dynamically constructed HTTP connection to CSV files held in a SharePoint 2013 document library
answered 18-04-2016 15:45:14 -0400

We have a SharePoint library where an external mechanism will routinely upload CSV files to (Note that the only constant will be that it will be a CSV file of a specific format, and SharePoint won't allow duplicate named files). In our testing we've s...

Answers: 1

CSV HTTP Sharepoint