Talend Data Prep, import excel worksheets

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[smallet]

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

[Anonymous]

Hello,

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

thanks 

Bence

[smallet]

Could you attach it please?

[smallet]

Do you expect something like this?

Which version are you using?

[Anonymous]

Yes, how did you do it?

[smallet]

Which version again?

[Anonymous]

2.1.1