topic Re: Talend Data Prep, import excel worksheets in Data Quality

Talend Data Prep, import excel worksheets

Anonymous — Sat, 16 Nov 2024 10:33:32 GMT

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

Re: Talend Data Prep, import excel worksheets

Anonymous — Fri, 01 Jul 2016 09:25:35 GMT

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

Re: Talend Data Prep, import excel worksheets

Anonymous — Wed, 09 Aug 2017 12:20:56 GMT

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

Re: Talend Data Prep, import excel worksheets

smallet — Wed, 09 Aug 2017 12:30:11 GMT

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

Re: Talend Data Prep, import excel worksheets

Anonymous — Wed, 09 Aug 2017 12:34:46 GMT

Hello,

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

thanks

Bence

Re: Talend Data Prep, import excel worksheets

smallet — Wed, 09 Aug 2017 12:57:12 GMT

Could you attach it please?

Re: Talend Data Prep, import excel worksheets

smallet — Wed, 09 Aug 2017 14:06:54 GMT

Do you expect something like this?

Which version are you using?

Re: Talend Data Prep, import excel worksheets

Anonymous — Wed, 09 Aug 2017 14:08:08 GMT

Yes, how did you do it?

Re: Talend Data Prep, import excel worksheets

smallet — Wed, 09 Aug 2017 14:26:15 GMT

Which version again?

Re: Talend Data Prep, import excel worksheets

Anonymous — Wed, 09 Aug 2017 14:39:01 GMT

2.1.1

Re: Talend Data Prep, import excel worksheets

Anonymous — Wed, 09 Aug 2017 16:54:05 GMT

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