Talend ETL Tutorial:
How to Migrate and Transform Excel Data to Load into Microsft SQL Server
The Excel spreadsheet has first and last name in one cell and the amount column contains values that are not written in a consistent format. The SQL server database that we want to load it into a a first name column, a last name column, an account name column and an amount column. Since we want the Excel data to correlate with the formatting in the SQL database we will use Talend to transform the data within a few clicks.
Find out how Talend extracts data, transforms it and eliminates the inconsistencies for the data can properly be loaded into the SQL Server database.