Q&A BY TAG 'CSV'
Files present in mount directory but not seen in ADLS container in azure portal UI
answered
24-12-2020 07:16:15 -0500
I am trying to export denodo view to ADLSv2. I am able to do the below things without any issues using Denodo Distributed File System Custom Wrapper connected to ADLSv2 container to read csv file from container created data source and base view i...
Answers:
1
Denodo on Azure BLOB azure blobl storage CSV Export Azure Data Lake Storage Gen2 azure
Error in Data source creation in ADLS 2 container
answered
13-12-2020 19:08:21 -0500
Hi, I am trying to establish a connection to read and write back a csv file ADLS 2.0 container. I am trying in custom wrapper so I configured my core-site.xml with my ADLS account with keys. When I try to test connection the connection is succes...
Answers:
1
CSV Create Base View Data sources Azure Data Lake Storage Gen2
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
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
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
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
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