UC1 - Get 2 Tables with 2nd Table Showing Details

This example shows how to have 2 tables, with the second table showing details about what you click in the first table.

See Also
UC2 - Get Sum of Values for an Entry
Defining and Managing Data Queries

Context:

Source csv file:

Goal:

  • Get a first table with the list of Line_No, and a second table with the list of SAPCODE.
  • Clicking a Line_No in the first table shows only its corresponding SAPCODE in the second table .

  1. In Data, for the first table, make a simple query using the DISTINCT operator to keep only unique values for Line_No.



  2. In Variable, use a query parameter and bind it to a variable.



  3. In Presentation, for the first table visualization, add an effect (On cell click) so that when you click a cell, the variable value is Line_No.



  4. In the second table, use the query parameter as a filter. Do that in the SEARCH operator Expression.