Merging tables using SQL filtration

Use case

You have two tables where the columns differ.

You need to merge two tables where the entries meet the conditions:

• transaction date in Table 1: October 2018
• customer type in Table 2: business

Solution

1. Switch the page to the edit mode.
2. Insert the Table Transformer macro and paste the tables or the macros outputting tables within the macro body.
3. Select the macro and click Edit.
4. In the Presets tab select Custom transformation and click Next.

5. Enter the following SQL query:

   SELECT
      * 
   FROM
      T1 
      JOIN
         T2 
         ON T1.'Transaction ID' = T2.'Transaction ID' 
   WHERE
      (
         'Transaction Date' >= "10 / 1 / 2018" 
         AND 'Transaction Date' < "11 / 1 / 2018"
      )
      AND 
      (
         'Customer Type' = "Business"
      )

   SQL

   WHERE ('...' >= "10/1/2018" AND '...' < "11/1/2018") AND ('...' = "...") extracts only those records that fulfill a specified condition.

6. Click Next.
7. Define the table settings and view options if needed.
8. Save the macro and the page.

You can use FORMATWIKI function for the purposes of cell formatting.