Table Functions

Applies to: TBM Studio 12.0 and later

How the table functions are used in a path?

In the TBM Studio Project Explorer view, select Tables.
Select a table (For example, table name: XYZ) > Check out XYZ).
Add a model step > select Model > select XYZ > select Use object identifier.
Select the dropdown > select Application Family and Application Function > select Save.
Now, you need to create a new report. Select New >Report > Write a report Name > Ok.Note: You need to start the report name with Text, and not with numbers.
Select the XYZ table in the Ad Hoc Component Configuration section.
In the Project Explorer, expand beside the XYZ table, then drag Application Family to Rows. The table components load with automatic grouping.
Right click inside the table > select Show full datapath. You can see the table functions GROUPBY, SORT, and LIMIT_COLUMNS.
To apply the !FILTER function in this table, click OK to come out of this window.
Now suppose you do not want to use Databases. Put !Databases here:
Databases is not there anymore. Now, right click inside the table > select Show Full Data Path. Now you can see the !Filter function

Check out an editable table.
Select Configure Columns > select Add a new column > select Possible Values >.
You can put your table function syntax in the Possible values > select Save > select Editable Table in the pipeline.
After the table loads, you will get a new column. You can click on the cells of the new column to select from the drop down with the table functions.

Learn more about the various table functions to get your values in the editable table: