About this task
Modify the data of your customers in your CRM, for example, convert all customer names to upper case.
Procedure
-
Double-click the tMap component and
enter
row1.CustomerName.toUpperCase()in front of the CustomerName column to convert all customer names to upper case. - Click Ok.
- Double-click the tMysqlOutput component.
- In the Action on table field, select None.
- In the Action on data field, select Insert or update to insert or update table data.
- Save your Job and press F6 to execute the job.
Results
To view all changes done on data, right-click the Leadfact table and select View All Changes to open the relevant dialog box.