one exc file with multiple sheet to migrate to one database with multiple tables

[modara]

Hi all ,

I need to migrate one excel file with multiple sheets to one database with multiple table

Example:​ one excel file name 'retail'

This excel file has few sheets 'customer', 'store', 'products', ,'date'

I need to migrate all theae shert with data to mysql or postgres database with in multiple table ​'customer', 'store', 'products', ,'date'

Table will be auto generated with all column header that comes from excel sheets

Pls assist

[Anonymous]

Hello,

You can get Excel sheet name in your job.

Here is a global variable from tfileinputexcel component: ((String)globalMap.get("tFileInputExcel_1_CURRENT_SHEET")) . (Depending on the name of your tFileInputExcel component)

CURRENT_SHEET: the name of the sheet being processed. This is a Flow variable and it returns a string.

Best regards

Sabrina

[modara]

Hello Sabrina,

Thanks for your answer. I am quite new to talend. Is there a way you can give me snap shot or step by step process

thanks