Combine columns in Table panel

Hi,

I have a query that gives me cityName and cityCode, that I can then display as two columns.
What I would like to do is display “cityName (cityCode)” as a value of one column.

I tried to search in transformations but couldn’t find anything to do this.

Thanks

1 Like

Depending on your data source you might be able to accomplish this with elegant use of templated alias.

Thanks, I have no idea where to start to do this though.
Do you have any pointers, docs I can read?

1 Like