Skip to main content
Question

ListBuilder issue - any help appreciated

  • November 9, 2020
  • 2 replies
  • 92 views
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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

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

@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!

Community Stats

32,154
Posts
122,047
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.