Q&A BY TAG 'csv'

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

Error in Data source creation in ADLS 2 container
answered 15-07-2021 05:27:29 -0400

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: 2

CSV Create Base View Data sources Azure Data Lake Storage Gen2

Getting the Source Tables and columns for non-JDBC datasources
answered 08-06-2021 09:36:53 -0400

Hi Denodo Team, For the views created from JDBC datasource in denodo I am able to get the source tables by using the default procedure GET_SOURCE_TABLES(). But when I use the same procedure to get the underlying source table information for the datasou...

Answers: 1

source tables SAP CSV Denodo8 JDBC Data Sources source columns DataSource underlying tables

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

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