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

  • Dataprep
12 REPLIES
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

Employee

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