Skip to main content
Question

ListBuilder issue - any help appreciated

sar_copp
Contributor
Forum|alt.badge.img+4

UntitledI am creating a 'school catchment finder' so when a user types in their postcode, it brings up a list of schools catchments that their address resides within (i.e. essentially a point in polygon query). I want the result to bring up a table of 10 school types regardless of if that school type has a catchment at that address or not e.g.

Primary School

Junior School

Catholic Infants

Catholic Primary

Academy School etc.

 

The issue I have is when using ListBuilder, if one of the school types is not present at that address, the column headings still appear, but a different school type is listed under the school name. This sets the table information off kilter.

E.g. If a Catholic Primary school is not present, they Academy School information appears under the Catholic Primary school headings which is obviously incorrect.

From the images below, can anyone tell what I am not doing correctly?

Untitled2Untitled3

2 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • November 9, 2020

@sar_copp​  If you're comfortable with Python, then a short python script could probably do this easily. See the end of this article: Transformers for Working with List Attributes

Alternatively, try dropping the ListBuilder. Instead, add a TestFilter after your Listexploder and split the schools by type. Then either have a separate AttributeCreator for each school or try the BulkAttributeRenamer and add the school type as a prefix. Once all the schools have been renamed, you could bring them together with an Aggregator.

sar_copp
Contributor
Forum|alt.badge.img+4
  • sar_coppContributor
  • Author
  • Contributor
  • November 10, 2020
markatsafe wrote:

@sar_copp​  If you're comfortable with Python, then a short python script could probably do this easily. See the end of this article: Transformers for Working with List Attributes

Alternatively, try dropping the ListBuilder. Instead, add a TestFilter after your Listexploder and split the schools by type. Then either have a separate AttributeCreator for each school or try the BulkAttributeRenamer and add the school type as a prefix. Once all the schools have been renamed, you could bring them together with an Aggregator.

Thank you, I will have a look at all that!

Reply


Helpful Members This Week

Community Stats

31,468
Posts
119,287
Replies
39,085
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.