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