Learn, collaborate and solve problems with like-minded data quality enthusiasts.
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…
Hi community, I successfully created an external system connection to a database schema, including credentials. However, when I try to create a dataset using the "Table or Database View" option, I notice that some tables are missing from the list. Interestingly, I am able to access and query those missing tables using…
What problem are you facing? When the Group step is used, we can only view rows in group on one value. What impact does this problem have on you/your business? Feedback received of this not being user friendly and having to exit the screen to be able to get to the multiple filtered values. Do you have any existing…
Workflows Workflows is the area in Data Studio where designer users tend to spend most of their time. For anyone new to it, imagine a data pipeline that manipulates one or more data sources through a number of stages and then does something with the results. Whilst a Workflow is easy to build by connecting different steps…
Hi, In my project, we are using Experian Aperture Data Studio(2.10.10) to connect to a Remote Find Duplicate match store(3.8.15) over http. The Find Duplicate step is configured with the 'Clear and re-establish store' checked as part of our requirements. Majority of the time ,the process runs end to end successfully,…