Updating existing rows

Use case

You have a table with dates and prices and need to move the dates two weeks forward and the prices 20% up.

Solution

1. Switch the page to the edit mode.
2. Insert the Table Transformer macro and paste the table with the dates and the prices.
3. Select the macro and click Edit.
4. In the Presets tab select Custom transformation and click Next.

5. Enter the following SQL query:

   UPDATE T1
   SET T1.'Date' = DATEADD(week, 2, 'Date'), T1.'Price' = ('Price' * 1.2);
   
   SELECT * FROM T1

   SQL
6. Click Next. 
7. Define the date format . 

8. Save the macro and the page.