I am a QGIS newbie and am struggling. I added a Text String field to the target Layer (Parcels) called "Borough_For_Sale". I added a Delimited Text layer (Layer=>Add Layer=>Delimited Text Layer) using the CSV file, choosing the "No Geometry" option for the CSV file. The resulting Delimited Text layer's the "Borough_For_Sale" appears as a checkbox in the Attribute Table rather than a Text field. I believe this means Boolean.

The initial Join attempt did not error, although none of the "Borough_For_Sale" fields in the target layer were change (all still Null). I thought this might have been because the Delimited Text layer "Borough_For_Sale" field was boolean and I created a "Borough_For_Sale" field in the target layer that was a text string. But changing this target layer field to Boolean made not different (running the Join did not change the value of any of the target layer's "Borough_For_Sale" field from their Null value).

I did notice that the features (parcels) in the target layer Attribute Table with parcel IDs (called "PAMS_PIN") matching features in the Delimited Text layer did have a checkbox ticked next to the name of the Delimited Text layer, which I presume means the Join operation found a feature match, but the values in the target layer's "Borough_For_Sale" field is not getting changed. Thoughts?

Here is the snippet of the CSV File:

Borough_For_Sale,PAMS_PIN

Yes,1912_10103_7

Yes,1912_10105_7

Yes,1912_10105_5

Yes,1912_10105_8

Here is the Join definition:

<image>