The place for most Aperture Data Studio discussion
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.
Hi, I want to explore using Rulesets, but the naming of rules is stumping me. I want my rule name to be the mapped column I am using, followed by a short description. Column=V_ID and description=not null. The rule name created though is "V_ID-Input - not null" - it is pulling in the input column from the ruleset definition…
I'm setting up a Dataset that automatically refreshes with data from files dropped into an External System dropzone (SFTP in this case). I only want to load specific files, determined by the file name. To do this, I was going to use the "Starts with file pattern" config option, but I couldn't find any information about the…
I am getting trend when using a different column in X axis than Date But when I am using Date the trend is not coming its BLANK. I have date as the Batchtime metadata, and I am trying to use the trend on below data I have done trend many time earlier where I had seen trend was coming good even if I have the date in x axis…
Is it possible or has it been discussed about having the option to specify a Space and Dashboard as a default at log-in?
Hi, I have the data interactivity available till this point in my workflow where I am doing multiple grouping and then brought them in one place by union Here is the Workflow screen shot, where till 1 (marked in the SS) I am interactivity . Output of transform step shown above. And now this I am trying to take in…
Is there a way to return multiple columns from the lookup table in return I have DS1 and looking up DS 2 and want to return 3 columns from DS2. My final output will be all col from DS1 and 3 cols from DS2. Trying with Lookup type "All Value" but in this option just getting 1 column in return
Is it possible to do below check I have this in one channel Want to check and populate 'Issue Pending' column value from other channel where it has comma separated values
Hi, I am trying to update an Issue List (approx 50,000 rows that need updating). I try and run a workflow to do this but it fails with the message below. I go to rerun the workflow and it runs for a while but then ends again. Each rerun only lasts about half the time as the previous one. I don't have access to the logs for…
Hi everyone, I’m looking to convert a SQL query in Aperture, which contains multiple CASE statements for a single column in the dataset. I’m looking for the best practices to achieve this efficiently and clearly. The column I’m working with contains various conditions that need to be evaluated. Could anyone share their…
hi, I am performing bulk data profiling on datasets using API automation where my steps are as below list all datasets to be data profiled in a csv file process csv for each row trigger dataset refresh and capture job id wait for job to get completed or for max 30 mins. if time elapsed is more than 30 mins then skip next…
This will be a special User Group event for us as we have an opportunity to share a real milestone in our product innovation. Our ‘new’ Aperture Data Studio is ready, and we’d love to have the opportunity to celebrate the enhanced capabilities together! We know you love data – by coming along you can exchange with your…