cancel
Showing results for 
Search instead for 
Did you mean: 

Determining if a field value is unique or distinct

Highlighted
NiCd Battery
How can I use a compute statement to determine if the value of a field is in a dataset is distinct or unique.  Or can I code a SQL statement in a compute statement?
Labels (1)
0 Kudos
4 Replies
Linear Actuator
Hi @CFresh,
  • If you are trying to explore the data to see if there are duplicates in the column, the quickest way would be to use a Filtergram
  • If you want to identify the data quality for many columns in the dataset profiling is the best solution. 
  • If the objective is to get the counts of certain fields and use that for further processing we have certain shaping operations like group by
Please let me know if you have further questions on this. 

Regards,
Shyam Ayyar
Product Manager
0 Kudos
Highlighted
NiCd Battery
Thanks for the different options.  Do you know if it is possible to export the Profile, ntot that I would print it, but I would use the freeze function so that the part number could remain in view when scrolling.  Thank you!
0 Kudos
Highlighted
Linear Actuator
Yes, the profile will be present as a Dataset in the Data Library and you could export this in the standard formats that Paxata supports. Thank you for the feedback on the freeze function, we will add it to the list of enhancements. 
0 Kudos
Highlighted
NiCd Battery
Both are good news, thanks!
0 Kudos