Concatenate fields in a feature layer

[Bud]

ArcGIS Pro 3.2.1; file geodatabase; standalone table

I want to concatenate a FGDB string field and a date field together in a dynamic/temporary feature layer. I don't want to create an output FC.

I'm not aware of any feature layer tools that can do that. And it doesn't seem to be possible in FGDB SQL in a database view.

Could one of the existing feature layer tools, such as Make Query Table, be enhanced so that we can concatenate fields?

For what it's worth, this is what it would look like in mobile or enterprise geodatabase SQL. 

t_species||' '||t_date

Result: 'Accipiter nisus 24-01-01'

[MarceloMarques]

My 2 cents. Certain SQL operations are only available in a RDBMS (Oracle, SQL Server, PortgreSQL) because the SQL Engine behind the RDBMS that is quite complex. Certain SQL functions in a File Geodatabase might not be available and it will be difficult to implement that because of this reason. Therefore, the best aproach is move the data from the File Geodatabase to an Enterprise Geodatabase, even Mobile Geodatabase will present some limitations as well, thus move the data to an Enterprise Database (Oracle, SQL Server, PostgreSQL). I hope this helps.

[Bud]

Here’s another example where a concatenate fields tool would have been helpful: Relate using multiple fields