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 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…
Hi Again, I have the below date column. I wanted to conver to to a proper date format like yyyy-mm-dd or dd-mm-yyyy. How can I do it? To Date or Convert to Date fucntions dont seem to be working :(
Hi, yet again I need assistance. I have 2 columns. One is an ID column, the other is a Data column. There are multiple entries of the same ID. I am looking for a way to select/filter out only those ID's with the latest date. Thanks in advance for any tips!
