Skip to main content

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

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