Hi, I have a project management excel spreadsheet, where some cell values go to one specific table, some other values go to others, and so on. Is there a way I can get only the specific data to input in the tables?
For instance, cell B3 will only be load into one table of my DB.
Solved! Go to Solution.
There are components on the exchange that might help with this. If they dont make it easy, you would need to set up a few filters to isolate each of the "special" cells (row filter to choose the row, then a tMap to chose the column)
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.