Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 13

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.

How

See the next pages for the details:

Children Display



What do I need to get started?

Section Columnwidth730px





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:

How to insert and remove the macros Section Columnwidth730px




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


Image Modified

column Sectioncolumn
width730px




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


Image Modified

Column Section Columnwidth730px




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



Learn how to:



Table Excerpt
namehome
Section


Filter

tables with the help of the various filter types

Column
width34%

Filter joint

170px

Image Removed

Column
width50%
Children Display
pageHow to use Table filter macro

:


Image Removed

Column
width33%

Build various charts based on joint tables:

250px


50%How to use Pivot table macro

:

Column
width
33%

Create a pivot table from

your table

joint tables, calculate and aggregate data

Children Display
page





Section


170px
Column
width
34%
Image Removed

Image Added


Column
width
50%

Build various charts based on your table

Children Display
pageHow to use Chart from Table macro

33%

Image Added


Column
width
250px

Image Removed

Column
width50%

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

Section
Column
width170px

Image Removed

Column
width50%

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

Column
width250px
Column
width50%

Find the answer to your question among the related FAQ:

33%

Image Added

  • What can I do if I can't find and add the macros?
  • How can I remove the macro accidentally added to a table?
  • Supported date formats