Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table Transformer is one of the macros bundled in the TableFilter app. The macro allows you to merge and associate all kinds of tables using both automatic presets and advanced SQL queries.

See the next pages for the details:

Children Display

What do I need

How to get started?


Section


Column
width730px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 1. Add the macro to the page in the edit mode:


Image Modified




Column

Read more:



Section


Column
width730px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 2. Place tables or macros outputting or including excerpted tables in the macro placeholder:


Image Modified




Column

Read more:



Section


Column
width730px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 3. Select the automatic preset or the custom transformation mode:


Image Modified




Column

Read more:



Section


Column
width730px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 4. Set the options and settings if needed:


Image Modified




Column

Read more:



Section


Column
width730px


Panel
borderColor#3b7fc4
titleColor#FFFFFF
titleBGColor#3b7fc4
borderStylesolid
titleStep 5. Save the macro and use the joint table in combination with other macros:


Image Modified




Column

Read more:








Table Excerpt
namehome
Learn how to:


34%33%
Section


Column
width
170px

Image Added


Column
width50%

Filter

joint

tables with the help of the various filter types

:

Children Display
pageHow to use Table filter macro


Build various charts based on joint tables:
Column
width
33%
250px

Image Added



Column
width
50%

Create a pivot table from

joint tables

your table, calculate and aggregate data

:

Children Display
pageHow to use Pivot table macro



Section


Column
width170px

Image Added


Column
width50%

Build various charts based on your table

Children Display
pageHow to use Chart from Table macro


Column
width250px

Image Added


Column
width50%

Use only one source table to build multiple charts and pivot tables



34%Image Removed
Section


Column
width
170px
Image Removed

Image Added


Column
width
33%
50%

Combine all the macros with each other and with built-in and third-party macros


Column
width250px
Image Removed



Column
width
33%
50%