CODEWITHSUNDEEP
azure-data-explorerkql
Dhiraj
Dhiraj

Reputation: 3696

projecting multiple columns in ADX with wild cards

If I have too many columns and a bunch of them start with similar strings , is there a way in Kusto to select them based on this pattern , such as using wild cards etc ?

e.g. Assuming we have some of the columns like datafield1, datafield2 ... , something like the following would be helpful

mytable | project datafield*

I know that this is not syntactically valid , so is there any workaround for achieving this easily?

Upvotes: 1

Views: 1173

Answers (1)

Slavik N
Slavik N

Reputation: 5308

project-keep does exactly what you want:

mytable | project-keep datafield*

Upvotes: 3

Related Questions