I have a database with 3 tables that indicate different statuses with the attributes: id, created, status
I have a single excel file with multiples tabs populated with data I will use to insert into my tables. So I already created an Excel metadata to select 3 sheets that are in the same format with the columns: key, created, id, status. I use Tmap to extract the columns I want to use and re-order them.
My question is now, how can I read data from these 3 sheets (1 sheet at a time) and insert the data into the tables I specify, So something like
Sheet 1,2,3 have the exact same columns.
Table 1,2,3 have the exact same attributes.
I need to use tmap to reorder columns before I insert into database.
I'm new to Talend, so your help would be much appreciated!
tfixedflowinput ( your sheet name and table name as data ) --> tflowtoitrate ( glob var will be created for sheet and table name automatically) --> tfileinputexcel ( in sheetname section add your globvar created for sheet name) --> tdboutput ( here tablename should be globvar created for table name)
You could also use tFileInputExcel (check All sheets) ------->tIteratetoFlow (current Excel sheet) ----->tDBOutput (Use table name as the row link created between tIteratetoFlow and tDBOutput)
thanks for your response. How can I set up tIteratetoFlow please? I just create something like
fileinput(using metadata)----->(iterate link)tIteratetoFlow------>tMap------>dbout
also as I have 3 sheets in file input, from tmap to dbout do I have 3 links? One for each sheet to db table insertion?
Inside tIteratetoFlow (after schema definition) use value for the column as the global variable of tFileInputExcel_Current_sheet
Don't forget to give kudos if your issue is resolved!
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.