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

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

how to get count of occurrences using Infotable API

AP_10343008
15-Moonstone

how to get count of occurrences using Infotable API

While taking distinct for any column in infotable, is it possible to get count of occurrences for each value along with distinct output?

ACCEPTED SOLUTION

Accepted Solutions

You can use aggrgate for such use case, 

Example:

 

Bikash_Panda_0-1706688420514.png

 

View solution in original post

2 REPLIES 2

You can use aggrgate for such use case, 

Example:

 

Bikash_Panda_0-1706688420514.png

 

Iam passing all the columns of datashape to aggregate service using for loop.

After aggregation, i couldnt get value from output infotable if i use

let value = infotable[i]."COUNT_"+FielName[i];

how to get these values?

 

 

Announcements


Top Tags