Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! 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