SOLVED

How to give Alias Name for Column

%3CLINGO-SUB%20id%3D%22lingo-sub-1168609%22%20slang%3D%22en-US%22%3EHow%20to%20give%20Alias%20Name%20for%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168609%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20help%20me%20how%20to%20give%20Alias%20name%20for%20expression%20column%20%3F%3C%2FP%3E%3CP%3EBelow%20is%20code%20in%20Azure%20LogAnalytics%20log%20query%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EAzureQuota_CL%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%7C%20%3C%2FSPAN%3E%3CSPAN%3Eproject%3C%2FSPAN%3E%3CSPAN%3E%20Name_s%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3ECurrentValue_d%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3CSPAN%3ELimit_d%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%20%3CSPAN%3E((%3C%2FSPAN%3E%3CSPAN%3ECurrentValue_d%2FLimit_d%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3CSPAN%3E*%3C%2FSPAN%3E%3CSPAN%3E100%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CP%3EBy%20default%20it%20is%20taking%20as%20column1%20but%20I%20want%20to%20customize%20column%20name.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EBrahma%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1168609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1168635%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20give%20Alias%20Name%20for%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168635%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F554371%22%20target%3D%22_blank%22%3E%40Brahmaiah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EIt%20is%20very%20simple%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3EAzureQuota_CL%0A%7C%20project%20Name_s%2CCurrentValue_d%2CLimit_d%2C%20MyColumn%20%3D%20((CurrentValue_d%2FLimit_d)*100)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1168678%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20give%20Alias%20Name%20for%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1168678%22%20slang%3D%22en-US%22%3Ethank%20you%20so%20much%20Stanislav%20Zhelyazkov%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

Can you please help me how to give Alias name for expression column ?

Below is code in Azure LogAnalytics log query:

 

AzureQuota_CL
| project Name_s,CurrentValue_d,Limit_d, ((CurrentValue_d/Limit_d)*100)

 

By default it is taking as column1 but I want to customize column name.

 

Thanks,

Brahma 

2 Replies
Best Response confirmed by Stanislav Zhelyazkov (MVP)
Solution

@Brahmaiah 

Hi,

It is very simple

 

AzureQuota_CL
| project Name_s,CurrentValue_d,Limit_d, MyColumn = ((CurrentValue_d/Limit_d)*100)
thank you so much Stanislav Zhelyazkov