Skip to main content Skip to complementary content

Modifying the CRM data

About this task

Modify the data of your customers in your CRM, for example, convert all customer names to upper case.

Procedure

  1. Double-click the tMap component and enter row1.CustomerName.toUpperCase()in front of the CustomerName column to convert all customer names to upper case.
  2. Click Ok.
  3. Double-click the tMysqlOutput component.
  4. In the Action on table field, select None.
  5. In the Action on data field, select Insert or update to insert or update table data.
  6. 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!