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?

Best answer by Bikash_Panda

You can use aggrgate for such use case,

Example:

Answer

14-Alexandrite

You can use aggrgate for such use case,

Example:

Author

16-Pearl

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?

Sign up