I would like to get a field value from a variable, but haven't figured out the syntax. The goal is to have the same value for each row, but that value should come from a variable.
I'm building the table called Selections step-by-step and in this step I want all the values of Field_A from MyTable to be linked to value 'Advanced'
'Advanced' as Selection
SET SelectionAlias = 'Advanced';
$(SelectionAlias) as Selection
I have tried a lot of things how to make the loading script to understand that it is not a field called Advanced I want to look for but instead the value 'Advanced' I want to have on every row. Hopefully it is just a simple question of correct syntax but I'm running out ideas what to try
I tried to look for similar questions but all I was able to find was how to get field values to a variable, but here I'm doing the opposite.