Foundation Documentation and SupportUser Use & Create TablesHow do I create a Horizontal Mashup Table?

How do I create a Horizontal Mashup Table?

Add a Table:

There are a couple ways to Add a Table:

Option 1: From the Home dashboard, click the Add button (below the Tables summary).

Navigate to the Table(s) Tools.

Option 2: From the Navigation menu, click the Tables option.

TMMData - - Google Chrome

Click the Add New Table.

TMMData - - Google Chrome

Enter Table Information.

  1. Name - What the Table is named.
  2. Description - What the description of the Table will be.
  3. Folder - What folder the Table will be located in.
  4. Status - What is the status of the Table? (Development or Production)
  5. Backup - Do you want the Table to be backed up?
  6. Order By - What Field the Table is ordered by.
  7. Order Direction - Choose if the order is Ascending or Descending.
  8. Primary Date Field - What Field is the primary date Field in relation to the sorting on Dashboards.
  9. System Index Fields - This allows you to index one of the system Fields for quicker loads.
  10. Table Onload Javascript - Allows Javascript or HTML code to be loaded once when the Table is opened.
TMMData - - Google Chrome

Click Mashup from the datasets.

- - Google Chrome

1. Select the Type of Join.

For this example we will select Only Matched Records.

Only Matched Records
Select the tables you wish to join and choose on what field they will link.

3. Select which Field(s) you wish to join on.

Select a Field from the Primary Table.

Select Field

Select what Field it will link to.  Note: There is a suggested Field to link on (based off of the name of Field).

Select Field

Congratulations, you created a link!

Note: You can create multiple linked Fields per Table.

Add Link

5. Select the Advanced tab.

When finished linking, click next.

6. Modify your Fields, if desired.  

From here you can rename Fields, move Fields, and also turn Off/On the visibility of the Field(s).

TMMData - - Google Chrome

7. Click the Save icon.

TMMData - - Google Chrome

Congratulations, the Table has been saved!