I am building a pipeline with a Mapping Data Flow activity in synapse analytics. I am trying to create a derived column with an expression similar to below. However, it fails with the error "Column functions not supported in configurations".
I need to dynamically get the list of column names and get the values on the fly. Looks like it is not working when I use byNames() function along with columnNames() function. Is there any workaround for this?
PS: I cannot use columns() function because I need to reorder or filter some of the columns.