Table Transformer Macro - Show All but One Column - Hide Columns

[Emily Berg]

I have a very large table, containing several dozen columns and would like to hide one or two columns using the Table Transformer macro.  The only way I know how to do this is to:

SELECT 'header 1', 'header 2', etc. for each column.  Is there an easier way to do this?

I would like to avoid using the table filter macro to hide these columns- why?  Because I have some UI buttons that I am using to filter the table (once my hidden columns are removed).  And if I have an embedded filter within a filter, the filter query breaks and my buttons do not work.  I find that if I can get the table transformer to filter the columns, then the filter macro with UI buttons works perfectly!  Sorry if this is confusing - I can provide more information / images if needed.

Thanks!

Emily

[Katerina Kovriga {Stiltsoft} · Accepted solution]

Hi @Emily Berg ,

You are right: there are two ways to hide columns.

The first one is not to list the header via the Table Transformer macro.

The second one is to use the Table Filter macro. You can hide columns inside the first (internal) Table Filter macro and hide the filtering panel for your colleagues not to change this setting. The second (external) Table Filter macro can be used strictly for filtering - here you may use predefined filters on the filtering panel, copy filters' URLs for your colleagues, etc.

The only moment we couldn't get is about the UI buttons - what do you mean by them? Maybe you can provide us with some screenshots and a brief summary?

[Emily Berg]

Hi @Katerina Kovriga {Stiltsoft} ,

I have a page with a large table and I would like to auto-filter for various groups within my team.  So I have added UI Button Macros to the page - goal being that I establish the filters in the Filter Table macro, copy the URL, and apply the URL to the UI button.  When you click the UI Button, it establishes the filtered table.  I have multiple buttons, including one to "clear" the filter and go back to the default table view.

It works beautifully when I use the Table Transformer to initially hide columns that I never want to be able to see.  Then I apply one Table Filter to the remaining table, establish the views, copy the URLs and apply to the button.  But as mentioned in my originally post, this is a very strenuous process because the table is large and selecting all columns to view is difficult - hard to manage if I continue to add / remove columns.  It would be easier if I could select columns to hide or even remove / delete from the table.

I have tried the two Table Filter approach - one embedded that always hides the columns of interest and hides the control panel - then a second that hides the remaining columns of interested depending on which button you click, essentially the global global.  I copy the URL of the filter and apply it to the buttons.  Usually the first click works, but if I click a different button with different set of filters, not all of the columns show, and sometimes the hidden columns from the first macro appear...it doesn't work!

I hope that helps explain the problem.  Any suggestions?

Emily

[Katerina Kovriga {Stiltsoft}]

Hi @Emily Berg ,

We know about such behavior: sometimes our customers use the one URL to filter several similar tables wrapped in the Table Filter macros and located on the same page.

In such cases the URL applies to several Table Filter macros (the same is happening for you: the internal Table Filter begins to show hidden columns).

So, I've added your case to our backlog and created a ticket - I'll get back here when there is an improvement.

[Spencer Cai]

Hi Katerina,  could you help to guide how not to list the header via the Table Transformer macro?   In the setting window, there is only " show all context"," hide all context"," hide table". I tried to use all of them but the header is still there. @[deleted] 

[Katerina Kovriga {Stiltsoft}]

Hi @Spencer Cai ,

It is not possible to hide the header row: the Table Transformer macro sees the source table as a mini SQL database, so the column name is the most significant part of the whole concept.

You may hide the unwanted columns though.

[Spencer Cai]

I see. I can use Table Filter to hide it instead.  Katerina, will you follow my ticket I raise in support? PSSRV-35831  Thank you 

[Katerina Kovriga {Stiltsoft}]

Not sure that I got you right: our support portal creates tickets with a TFCS project name and with less numeric numbers.)