Download page Extracting column headers/names from a table.
Extracting column headers/names from a table
Use case
You need to gather all column headers/names through the table for further display in a table.
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 RETURN (@TABLE1) AS @TABLE2 FROM T1;
SELECT '0' AS 'All Columns' FROM @TABLE1
CODE
Save the macro and the page.
The use case is highly viable for the configs involving complex tables with numerous columns, allowing to quickly gather an aggregated display of each column header for further processing.
Cookie Notice
This website uses cookies for analytics, personalization and advertising. By continuing to browse, you agree to our use of cookies. Learn more