Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

Talend Data Prep, import excel worksheets

Highlighted
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

Highlighted
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.
Highlighted
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

Highlighted
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)?

Highlighted
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

Highlighted
Employee

Re: Talend Data Prep, import excel worksheets

Could you attach it please?

Highlighted
Four Stars

Re: Talend Data Prep, import excel worksheets

 
Highlighted
Employee

Re: Talend Data Prep, import excel worksheets

Do you expect something like this?

Sélection_001.png

Which version are you using?

Highlighted
Four Stars

Re: Talend Data Prep, import excel worksheets

Yes, how did you do it?

Highlighted
Four Stars

Re: Talend Data Prep, import excel worksheets

 
Highlighted
Employee

Re: Talend Data Prep, import excel worksheets

Which version again?

Highlighted
Four Stars

Re: Talend Data Prep, import excel worksheets

2.1.1

Highlighted
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 GARTNER 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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads