topic Re: import excel to sql table in the same order in Talend Studio

import excel to sql table in the same order

joelle_alhanna — Fri, 15 Nov 2024 23:06:34 GMT

dear,

I have an excel file with multiple sheets. I need to import it to SQL table with the same row order as excel.

I use the tfileimputexcel and all sheet are imported to SQL table. my problem is the row order of the table is not the same as the excel file.

Meaning I want the first sheet to be imported then the 2nd then the 3rd...

please advise how can I solve it

thank you

Re: import excel to sql table in the same order

Anonymous — Thu, 17 Mar 2022 05:26:38 GMT

You check 'All sheets' box or input the sheet name in the Sheet List? maybe input the sheet name in the Sheet list will ensure the sheet is read in order.

Regards

Shong

Re: import excel to sql table in the same order

Anonymous — Thu, 17 Mar 2022 06:58:25 GMT

Hello,

We need more information to address your issue.

For testing only, could you please use tLogRow as output to see if all your sheets with the same row order as excel can be printed on console?

Are there any datatype changes which would cause the order/sequence changes? Did you use tMap as a middle component?

Best regards

Sabrina