Talend Data Prep, import excel worksheets

One Star

Talend Data Prep, import excel worksheets

I'm exploring Data Preparation Free Desktop, and trying to import an Excel file. I'm only getting the first worksheet. Is it possible to import all worksheets in an Excel file?
Thanks,
Mark

Moderator

Re: Talend Data Prep, import excel worksheets

Hi,
It is unable to import data from multiple sheets or files to one dataset. You can create a general DI job to merge the data from multiple sheets or files to the same sheet in a file, and then import the data to talend data preparation tool.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Talend Data Prep, import excel worksheets

Hello,

 

I have  a problem with upload data. Data prep doesnt allow me to upload any file to dataset or data prep.

Ive tried with csv, txt, Excel

Employee

Re: Talend Data Prep, import excel worksheets

Hi,

 

With a multi-sheet xls file, the tool should ask you to select one (one sheet=one dataset).

Could you attch here samples of files that doesn't work (csv and xls)?

Four Stars

Re: Talend Data Prep, import excel worksheets

Hello,

 

I have one sheet csv file, what is produced by talend studio after tmap.

 

thanks 

Bence

Employee

Re: Talend Data Prep, import excel worksheets

Could you attach it please?

Four Stars

Re: Talend Data Prep, import excel worksheets

 
Employee

Re: Talend Data Prep, import excel worksheets

Do you expect something like this?

Sélection_001.png

Which version are you using?

Four Stars

Re: Talend Data Prep, import excel worksheets

Yes, how did you do it?

Four Stars

Re: Talend Data Prep, import excel worksheets

 
Employee

Re: Talend Data Prep, import excel worksheets

Which version again?

Four Stars

Re: Talend Data Prep, import excel worksheets

2.1.1

Moderator

Re: Talend Data Prep, import excel worksheets

Hi,

 

Can you provide the Data Prep log file, which is located in C:\Users\<your username>\AppData\Roaming\Talend\dataprep\logs?

 

Thank you,

 

Gwendal

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch