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 everyone, In this post I'd like to provide you all with a sneak peak of a new real-time data quality enforcement offering that we're currently exploring, that we'd love to get your feedback on (complementing our existing contact data validation products). The idea centres around exposing Data Studio functionality (e.g.…
For our customers on the Aperture Data Studio Hosted and Managed Service: The maintenance schedule is now available on the Community site at this section. There is also an option to subscribe to maintenance status updates at the Experian Data Quality status page.
Hi, I thought I had this set up correctly, but testing reveals otherwise. I have a reusable workflow that is set up to send data passed to it to an external destination (as an Excel file). However, I only want to run this when the data being fed has rows. The reusable workflow is fine when used in a workflow - it uses the…
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…
