SAP Datasphere - Rename Columns in Batch or Add Prefix - for Join table with itself

[axel_]

Hi Folks,

I need to join a table with itself as the records in the table itself are connected with each other.

Is there a way to attach a prefix to the column names or batch rename as data builder will complain in the join result about duplicate column names.

Manual rename is not really viable as we are talking about 500+ fields.

Best regards
Axel

[axel_]

Hi Irvin,

using SQL view will work. If you now can tell me how to set the business name in the SQL view you will make my day!

Select "ID" as "VK_ID" from table1 will set technical name correctly to VK_ID but business name will stick to ID.

Best regards

Axel