Q&A BY TAG 'CSV'

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

Sharepoint/OneDrive directory access to get CSV or Excel Files
answered 18-06-2020 06:58:01 -0400

Hello Denodo! We've been trying to get all the instructions in the following links to work with no success: https://community.denodo.com/answers/question/details?questionId=9060g000000Xf4oAAC&title=OneDrive+Connetion https://community.denodo...

Answers: 4

Datasource OneDrive Excel CSV Sharepoint

CSV Filename Column
answered 11-06-2020 06:44:58 -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: 4

CSV

How to connect to a csv file placed in an HTTPpath?
answered 19-05-2020 04:38:02 -0400

Hi Team, I need to connect to a csv file placed in https path . Every day this path will get updated with a new csv file to which denodo needs to be connected and extraced the data. I tried to create using 'Delimited file' but the data doesnt show up ...

Answers: 1

HTTPS csv

Create a folder dinamically in Scheduler
answered 21-11-2019 16:03:22 -0500

I need to create a CSV exporter and I need that this exporter create a folder with the date. Is this possible? Example: /output/20191120/extract.csv /output/20191122/extract.csv ...

Answers: 1

folders Job scheduler CSV

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

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