Learn, collaborate and solve problems with like-minded data quality enthusiasts.
The Data Quality Community is a great place to collaborate, seek answers, and learn Aperture Data Studio. Register for free to join in with discussions.
Explore what’s new and shape what’s next in Aperture Data Studio You’re invited to join our Data Management User Group - a dedicated space for Aperture Data Studio users to learn, connect and collaborate. Get exclusive insights into the latest platform developments and roadmap and hear how leading organisations are…
Dear Aperture Data Studio users, I hope you had a great bank holiday! We’re excited to share a quick update to the Experian Learning platform (specifically the Aperture Data Studio area) and invite you to showcase what you’ve learned. We recently enhanced the platform with shareable learning achievement badges, and a…
Hi, I am looking for a quick (I hope) solution. I have example data on the left. I want to split the 3rd column into separate rows to get what is on the right side. Is there an easy way to do it? Thank you very much in advance for your help! DE 0021 OQY DE 0021 O DE 0022 OY DE 0021 Q DE 0023 Z DE 0021 Y DE 0022 O DE 0022 Y…
What problem are you facing? We have a number of data quality dashboards that are used by our data consumers. These each contain around 20-30 datasets/views showing the records that have failed a data quality rule, for users to investigate. Each dataset comes from a different report. To make it easy to scroll up and down…
Hi again, I have 2 datasets. One has columns Land1 and ZWELS. ZWELS can have multiple characters entered as you see on the first screenshot. The second Data set has also LAND want and the column ZLSCH which can only have a single character. What I want to to is join my datasets on LAND1 + every single character from ZWELS…
Hi, I have an Excel file(s) that I get sent back to me with data that I need to import into Aperture. The Excel has 2 worksheets in it, and in Aperture the dataset is configured as 2 tables (see screenshot). I have set up automation to capture when certain datasets are successfully loaded, with the results going to a…
Hi everyone, Has anyone worked on pulling data from the Aperture database to track how users interact with dashboards? Specifically, I’m looking to capture events like dataset downloads or chart expansions. Any solutions or past requests for something similar?
Hi, I was searching for a function that does the opposite of 'Add Period' (e.g. a Subtract Period) as I wanted to minus some period of time. In fact the easiest solution was already there, and was to use a negative number in the 'Period size'. For example, using 'Time period type=Days', 'Period size= - 7' will get the date…
Hi All, We would like to setup a daily table refresh from an SAP database into Aperture, and we want to only pull the delta (incremental) records. To achieve this, we need the extraction to be dynamic. The system should somehow determine and add to the query for example, the date of the last record (for example, by…
Hi Team, We are trying to connect Databricks workspace from Aperture Data studio.But our platform team is not suggesting to use PAT token for data bricks connectivity. Kindly let me know if anyone is connecting Databricks using the service principal Oauth from Aperture Data studio. if so kindly share the details. Regards…
