Row to column in table?

Question

Hi all,

I am trying to make a snappy looking page on experience builder. Basically, on another page view on this ExB, a person can select their property on a map and see some basic details. On this page, there's info about the selected features. I want to grab some cells from the database about this property and put them into a snappy looking table (see the attached version from another county). But in the example I'm showing, the data are in two columns that would be both the field names in my database and then the info from one row about one property.

If I insert a table widget then it's going to give me just one long row with columns for all of the things I'd like to show. If I insert a feature info widget I get it displayed vertically, but it's showing more rows than I want for this dataset (I have another view that uses the feature info widget so I need to use all that info in that other view).

The only thing I can think of is to stack text boxes with dynamic text in a block. This seems terribly time consuming and wasteful. Is there another more elegant way to transpose date from the attribute table into a vertical table?

Shen_Zhang · Answer

You can go to the Data tab to add an SQL clause to filter the feature table. Please note these SQL clauses apply to all the widgets that are using the same data.

Maartenvan_der_Veen · Answer

Hi @Shen_Zhang ,

This is already super useful for me. Is there a way now, to filter the feature table so it wont show rows with a zero value? This would be super useful to reduce the lenght of the feature table, based on the selected element.

best ,

lotte

Shen_Zhang · Answer

Hi @KBKnight

Currently table widget does not support display records by column. For feature info widget, it does not support customize fields to be displayed either (I think it's a good point though) - since fields cannot be configured in expression builder when creating data views.

A possible walkaround:

* In ArcGIS Online or your Portal, create a view layer from the layer you use, select only fields you would like to display

* In Experience builder, add a feature info widget and use this field-customized view layer as data source. Choose Selected view

* Configure a Record selection changes action from the widget you would like to interact with (I used a table as an example), target the framework and choose this field-customized view layer as target data

* When switch selection from table, record in feature info will change accordingly, with fields you specified in the view layer.