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)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables