Forum Discussion
pmscorca
Post Prodigy
Post ProdigyCreating a materialized view in KQL language with only some table columns
Hi,
I need to create a materialized view that must expose only some table columns with a similar KQL code, that goes in error:
.create materialized-view mv_test on table mytable
{
summarize arg_max(version, *) by id
| project id, version, column1, column2
}Moreover, is it possible to return one of this columns converted in a datetime?
Thanks
Hi,
I've solved with a such statement:
.create materialized-view mv_test on table mytable { mytable | extend duedatetime = todatetime(duedatetime) | project id, version, duedatetime, column1, column2 | summarize arg_max(version, *) by id }Thanks
2 Replies
pmscorcaHi,
I've solved with a such statement:
.create materialized-view mv_test on table mytable { mytable | extend duedatetime = todatetime(duedatetime) | project id, version, duedatetime, column1, column2 | summarize arg_max(version, *) by id }Thanks
Hi pmscorca ,
Glad to see you solved your problem yourself, please remember to mark your reply as SOLUTION so that more users can find solutions and learn faster. Thanks!
Best Regards,
Dino Tao
