Forum Discussion
Manuael Column Labeling
Hi Yrstruly2021 ,
So you have two tables both have label column and you want to merge these two tables and keep two lable columns with different names?
If so, it is more convenient to do this work in sql. If you want to do this in Power BI, you need to load these two tables, then use the Merge Queries feature to merge the two tables as one, as last rename the two label columns.
Best Regards,
Jay
Yrstruly2021 ,Issue is not clear
depending on database rename should be in double quotes or []
example
select a.label as "App Category" -- or [App Category]
, b.label as Menu
, c.product_uid as ProductUID
from app_menu_filters a
left join app_menu_filters b on b.parent_uid=a.uid
left join app_menu_filter_products c on b.uid=c.app_menu_filter_uid
where a.status='A' and a.level=1
order by 1,2,3;