Hello Forum,

I am reading in two .csv files into FME Form...

csv 1

Candidate_UPRNs.csv

This has just one column: candidate_UPRN. It contains 100 records. Each record contains a UPRN value in the candidate_UPRN attribute.

Note for those outside UK: the UPRN is the unique property reference number (UPRN) from the Local Land and Property Gazetteer (LLPG). As the name suggests, the UPRN is unique and can not be repeated. UPRNs are managed in the LLPG.

csv 2

LLPG_PAs.csv

This is an extract our entire LLPG with around 169,000 records. It contains multiple columns including UPRN. 

I want to filter LLPG_PAs.csv down so that I am only using the records that match (using the UPRN value) with the records in candidate_UPRN.csv (i.e.: the 100 records).

Before I take the workspace on further from that point I need to establish the filter first.

I’ve looked at SpatialFilter, but not sure that’s ideal. Any advice would be welcome.

Thanks,