Manuael Column Labeling

[Yrstruly2021]

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 

[v-jayw-msft · Accepted solution]

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]

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 ? 

[amitchandak]

@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;