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.
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…
Hi, Was hoping fellow-customers or Experian staff would be able to give their experiences with this one. Wanting to update data in the DB directly using Aperture (thru the Export step - JDBC), but the DBA wants updates done via SQL scripting (is hesitant to use Aperture). I am pushing for Aperture as it is a controlled,…
Hi, We are using Experian Aperture Data Studio version 2.14.14.40 and have changed the settings to accept csv delimiter to pipe (|) But there is a requirement to delimit csv files based on runtime configurations. Is there a way to define the delimiter in the export step while writing datasets as csv likely from a parameter?
Waiting to get an external system set up to allow updates via JDBC - in the meantime, if I select mode = UPDATE in the export step, does a full SQL statement get generated (to allow our DBAs to verify and QA the process). Thanks
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…