Microsoft Secure Tech Accelerator
Apr 13 2023, 07:00 AM - 12:00 PM (PDT)
Microsoft Tech Community

Combine 2 columns in Single coulmn in KQL

Occasional Contributor

Hi ,

I have data in sign-in logs as username and location, I want to combine username, location columns and add it to 3rd column. How I can do it in KQL.

I have data like- 

User NameLocation

I want it like following- 

User Details
User-1 - IN
User-2 - US
User-3 - GB
User-4 - MX
1 Reply
| extend ['User Details']=strcat (['User Name'], " - ", Location)