import excel to sql table in the same order

[joelle_alhanna]

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

[Anonymous]

Hi

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

[Anonymous]

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