I want to highlight parts of a map based on the page number in an atlas. Ideally I'd use the expression builder in the layer style menu to set the Column to equal the atlas page number.
My expression is as follows
@atlas_pagename || '_1'
The page number is "1007" and the column is "1007_1" hence the need to add the _1 at the end. The next column is 1008_1 for example.
The expression successfully outputs 1007_1, but the expression builder doesn't recognise this as the name of a column.
Is there any way to make the expression builder not just output "1007_1" as a string, but to select the column "1007_1"?
I am trying to do this automatically with an expression so that when the atlas moves onto page 1008 the layer will move onto column 1008_1 and so on.