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 All, Is there a way to calculate the working hours between 2 timestamps - start date and end date. We would like make this calculation for our KPI measures. We need to exclude the weekend hours as well somehow, so the result should be the exact hours, minutes, seconds. Let me know if you have any ideas! Many thanks!…
Hello. I am on ADS 2.8.8 currently and I am facing an issue when trying to load .xlsx as a dataset. Some, but not all floating point numbers are read incorrectly (see screenshot below). I have read the post below and understand this might not be possible to resolve instantly I just wanted to ask that aside from using other…
I have a dataset which is semi-structured which has columns with multiple values split by different delimiters in different positions e.g "'123',' 456'; '789' & '321' and '654'" The excel function TEXTSPLIT can easily split the data into multiple columns easily but i'm struggling to find a function in Aperture which does…
Hi, Is there a way we can delete the data in the dataset by setting up some Process? For example running a WF to delete the data in the Dataset. But we want to keep the Dataset metadata. Thanks.
Hi there, Does anyone came across a problem of the wrong datatype coming from the outputs produced by aperture that goes to Azure Data Lake? According to the my colleague Data Engineer the outputs need to be the long data type. Just checking if anyone knows anything about this to offer me some support. TIA
Hello, I wonder if you can help me come up with a solution. How to replace values from one input with values from another, where the new value is calculated with an expression. Example below: input 1: input 2: Result: Input 2 is dynamic so I'd need a tool that can read the expression/ statement from Input 2 and apply to…
@henry_ @Henry Simms @Josh Boxer We are trying to Build the External System connection through API in Aperture, the authentication method is OAuth 2.0 I am able to get the response in Postman and also able to Download the JSON file and then process the Same in Aperture, then i can see the Table and also the records. But…
Hi, I have a dataset that is 'Interactive' (can see the failings rows). Once I pull it into a new workflow, to do some filtering, transforms etc, I can no longer make the resulting snapshot interactive. Is there a way I can enable this? T Troubleshooting revealed it is nothing to do with the steps in the workflow, even if…
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…