Download page Searching for a specified pattern through the entire table.
Searching for a specified pattern through the entire table
Use case
You need to find any values/value patterns across the entire table(every column) for further display in a common column.
Solution
Switch the page to the edit mode.
Insert the Table Transformer macro and paste the table within the macro body.
Select the macro and click Edit.
Switch to the SQL query tab.
Enter the following SQL query:
SEARCH / AS @TABLE1 / AS @Pattern RETURN(@Pattern as 'Data Found')
where(@Pattern::string->includes("IP-1")) FROM T1
CODE
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.
Cookie Notice
This website uses cookies for analytics, personalization and advertising. By continuing to browse, you agree to our use of cookies. Learn more