Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
Hello,
Is it possible to query an infotable you have created? For example, I have a column with numbers in it. I want to sum those numbers up and group by an expression in another column.
Thank you,
Mike
Hi Mike,
For future reference, this is possible (see the
Query()
InfoTableFunction in the Snippets tab), but querying an InfoTable would not be the correct way to achieve your desired result. Instead, you'll want to use the
Aggregate()
Service in conjunction withDeriveFields()
.You can reference section "05.01.03.12 InfoTableFunctions" of the Wiki for more information.
Thanks,
Adam