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