Query Infotable

[ptc-6292144]

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

[adam11]

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 with

DeriveFields()

.

You can reference section "05.01.03.12 InfoTableFunctions" of the Wiki for more information.

Thanks,

Adam