Hi,
I'm struggling with adding a custom column which should CONCATENATE Field A with Field B in the Query Editor.
Whenever there is either a number or a Date Time value in one of the fields, I get the following error message:
Expression.Error: We cannot apply operator & to types Text and Number.
It works well with the Merge Columns function, though. I can also add custom columns with calcuations on numbers in Fields A and B. The format of the custom column has no influence on the error state.
Any idea how to concatenate fields with number values in a custom column?
Thanks
Thomas
