Forum Discussion
Prashali_Shinde
Jan 16, 2023Copper Contributor
Combine 2 columns in Single coulmn in KQL
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 Name | Location |
User-1 | IN |
User-2 | US |
User-3 | GB |
User-4 | MX |
I want it like following-
User Details |
User-1 - IN |
User-2 - US |
User-3 - GB |
User-4 - MX |
- Clive_WatsonBronze Contributor| extend ['User Details']=strcat (['User Name'], " - ", Location)