Idea: Table View - Hide all empty fields option?

ZhouNan · October 24, 2012 5:15AM

Hi,

I have a data file which generates six different data sources from database, and each data source is populated in an individual tab. Because there is few overlapping column names, it ends out about 150 fields in total.
So, the problem now is that when user clicks any parts of the data in any tab and view the details, it shows all the fields including 100 or more empty and unrelated columns (as shown in the attachment) although the unrelated data sources are filtered out by Source filter.

I am wondering if there is a easy and centralized way to manage the fields shown in Details view on each tab. Or, do I have to manually hide all the unrelated columns in each graph and do the same for the other tabs which might a huge amount of zombie work.

Thank you very much!

ZhouNan · October 24, 2012 5:58AM

I don't want to delete the fields from the Field Organiser, I want to hide the empty fields unrelated to the current tab but related to the other tabs.

For example, as show in the attachment, there are two different data sources used on two different tabs. On Coins tab, I want to hide the fields in the right red box in Details view which are unrelated to the current tab .

My question is that it is easy to hide them manually for each graph when there are 5 or 6 unrelated fields; but it is hard to do when there are about 100 ones. So, I'm wondering if there is a centralised way to hide it at data source level,

Thanks!

tjbate · October 24, 2012 8:50AM

Zhou - Double click on any row header to bring up the Record Details pop-up window. Make sure the option Configure > 'Hide blank values' is ticked?

ZhouNan · October 24, 2012 9:01AM

Tjbate-Thanks! It is ticked and works as expected. But I only found the tool bar in Record Details pop-up window for single record. Is it any similar function in the Right Click - Show Details view where data is listed in a table when the number of records are over one.

tjbate · October 24, 2012 11:05AM

Zhou- Currently the multi-record details pop-up takes its settings from the last-configured Table View on the tab...you can create a floating Table View, and use the fields picker to define the columns to show

There is not currently a Table View option to simply hide all empty fields/columns from the view, which would be inherited by the multi-record details view and could be copied across all tabs. I have re-classified this as an Idea.

ZhouNan · October 24, 2012 11:12AM

Tjbate-Thanks for the suggestion! I think the alternative method I will go for is to hide the fields unrelated to the tab in Data - Manage Fields. It works fine; just too many empty fields need to be hidden which is not a small amount of effort for a large scale of data.

tjbate · October 24, 2012 11:39AM

Zhou - Be careful because the global hide field option in Manage Fields will hide the field/column globally, i.e. from all subsets/sources. If you have created the file by appending many different unrelated sources with few shared columns, then you do not have columns/fields which are really globally empty...they are only empty for defined subsets, those that relate to other sources. What is needed for this case is a subset (not global) option to hide empty fields.

ZhouNan · October 25, 2012 5:11AM

Tjbate - Thanks for the reminder! You are absolutely right! In the Manage Fields option, it allows you to hide the fields just on current tab or cross all tabs. So, I have to hide the unrelated fields just on the current tab and configure the other tabs in the same fashion.

Welcome!

Categories

Ideas Parade

Tagged