Experian Data Quality Community
-
Suggestion: Auto-Save rules in a validation step
Hi, I have come across something rather infuriating this afternoon whilst creating a number of validation rules within the same rule group. Having spent the best part of 2 hours creating around 20 rules I briefly lost connection, after reconnecting I had to navigate back to the validate step. … all my rules were gone…. Can…
-
Calculate the distance between two sets of co-ordinates 🌍️
Summary Returns the approximate distance in kilometres between a pair of geographical co-ordinates. Input latitude1, longitude1, latitude2, longitude2, output value is distance between each set of co-ordinates while considering the spherical nature of earth using the law of haversines. Example Buckingham Palace, London is…
-
Pushdown Processing Advanced Function Mapping
Evening all, We're looking at implementing pushdown with Snowflake and have hit a couple of functions where we've had to workaround to avoid blocking the pushdown process. However, this advanced function mapping (as per documentation screenshot below) may help us fill some of those gaps and keep our workflows simpler. 3…
-
Suggested approaches for manipulating JSON values
My data includes a column containing JSON values - I've made a dummy example below: https://us.v-cdn.net/6031645/uploads/CNP6XDWHH24R/color.csv Example JSON value: { "magenta": "#f0f", "yellow": "#ff0", "black": "#000", "usageList": [ "giraffe", "lion", "axolotl" ], "properties": { "cost": 99, "difficulty": { "part_a":…
-
Useful Function: Distance between two coordinates
Recently developed a function based on the Haversine Formula to generate the distance between two coordinates (in meters). It's useful for comparing distance approximations between different address points. Simply copy the below text into the function script editor: param Point 1: Latitude; param Point 2: Latitude; param…
