Q&A BY TAG 'CSV'

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

CSV Filename Column
answered 25-10-2022 12:42:25 -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: 5

CSV

Unable to create base view with CSV as a data source
answered 08-11-2021 06:37:46 -0500

Hi Team, I am trying to create a base view with CSV as a data source created. The data is stored in my local. The connection is successfully created but when I try to cretae the base view it just keeps loading sign showing and nothing happens post tha...

Answers: 1

CSV

Skiiping first 3 rows in csv datasources
answered 05-11-2021 03:20:18 -0400

Hi How to create a datasource for a csv delimiter which i need to skip first 3 rows of the file? the first 3 lines has description about the data and it has only one column and starting from 4th line it has 10 columns.

Answers: 1

CSV

Dynamic Path for Custom S3 Wrapper
answered 31-08-2021 09:05:29 -0400

I have a backup file that is time stamped like this each day: GDW_08-30-2021.csv The current path to reference this file in the custom wrapper via AWS S3... looks like this: /gdw_backup/GDW_08-30-2021.csv is there a way to embed a caclulated value ...

Answers: 2

Formula Dynamic CSV AWS S3 Distributed File System Custom Wrapper

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

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