Hello @mschindelman,
Knowing that you’re getting data in Direct Query Mode from SQL made me think of another possible solution: you could build a View in SQL with all the data that you need and add there, as a separate column, the concatenation of the Picolt and CoPilot .
If you liked my solution please give it a thumbs up 
.
If I did answer your question please mark my post as a solution 
.
Thank you !
Cristian