Use case

You need to find any values/value patterns across the entire table(every column) for further display in a common column.

Solution

  1. Switch the page to the edit mode.
  2. Insert the Table Transformer macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. Switch to the SQL query tab.

  5. Enter the following SQL query:

    SEARCH / AS @TABLE1 / AS @Pattern RETURN(@Pattern as 'Data Found')
  where(@Pattern::string->includes("IP-1")) FROM T1
  6. Save the macro and the page.

The includes("your value/value pattern") part is where the value/value pattern is added for searching, while the RETURN( @Pattern as 'YOUR NAME')  part enables customizing the column name and changeing its aliases.



  • No labels