I am looking for a work-around to remove some fields (attribute columns) from a layer's table by a query.
For example, there are 10 columns in a table, remove 9 and leave only one (virtually).
Now, if I run 'Join Attribute by Location' tool, I should only get one column attached to the new 'join layer'. This is so that I could get only the desired attribute column in the output 'join layer'.
Once I finish this task, I should be able to display all original columns back as they were in the layer.
I know there is an equivalent in ESRI's ArcGIS, but not sure about QGIS.