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.
I am in Aperture Version 2.8.8.27 I am trying to get connected to Googlesheet thru BigQuery. BigQuery is set up with link to Googlesheet and connection to BigQuery from Aperture seems to work ok. External system Connection is OK, using Service Account with .jason Private Key File. But when I try to add dataset in aperture…
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…
