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
- Switch the page to the edit mode.
- Insert the Table Transformer macro and paste the table with the dates and the prices.
- Select the macro and click Edit.
- In the Presets tab select Custom transformation and click Next.
Enter the following SQL query:
UPDATE T1 SET T1.'Date' = DATEADD(week, 2, 'Date'), T1.'Price' = ('Price' * 1.2); SELECT * FROM T1
- Click Next.
- Define the date format .
Save the macro and the page.