Forum Discussion
Manuael Column Labeling
Can i make a copy of Label column and name the two columns as "App Category" and "Menu" instead of running the following SQL?
# App Filter Categories
select a.label as 'App Category'
, b.label as 'Menu'
, c.product_uid as 'Product UID'
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;
See: https://drive.google.com/file/d/1Bb_UPIws52ZcY_SpcsLXcEJMdZfp5t7k/view?usp=sharing
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
3 Replies
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;Thank you. I just cant seem to figure out where is the two categories drawn from when i manually search for it in my dataset: https://drive.google.com/file/d/1zqSbAvESHf5WUw4U-OKXjL_9E8NbJTfd/view?usp=sharing ?
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
