Page tree

Versions Compared

Key

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


Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:


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 to get started?





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


Image Added







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


Image Added






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


Image Added






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


Image Added






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


Image Added





Learn how to:



Section


Column
width34%

Filter joint tables with the help of the various filter types:


Column
width33%

Build various charts based on joint tables:


Column
width33%

Create a pivot table from joint tables, calculate and aggregate data:





Section


Column
width34%

Image Added


Column
width33%

Image Added


Column
width33%

Image Added