Table comparison - Find and mask differences

Hi @mforrer,

I’m not @ipazin but I might have a solution for you.
First I just want to summarize my understanding of your use case:

  1. you have a big table and want to detect outliers.
  2. you want to collect information on those outliers to review with the customer to determine if they are accurate values or errors.

I threw together a workflow that will loop through the columns in your table and collect information on outliers. In my example it saves the original value, the average column value, and the standard deviation of the column.
This is then presented in a table view where you can select which outliers are true errors and which are just unusual data points.


Let me know if I’ve understood your problem correctly, a more exciting visualization is definitely possible at the end but I just left it simple.
Best of luck!
Corey.

2 Likes