How can I set a exist column value to a macro
As below, i have a column "concat(lot_id)", i want to set this column value to a macro which named "input"
Then i can use this macro in SQL like:
But if I do like this, macro input value is always [concat(lot_id)], so what did i do wrong, and how can I set a exist column value to a macro?
Look forward your help, thanks!