cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Query Infotable

ptc-6292144
3-Visitor

Query Infotable

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

1 REPLY 1
adam11
5-Regular Member
(To:ptc-6292144)

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



Announcements


Top Tags