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.
Our tech team previously applied a cert to the server a couple of weeks ago, now we are looking to upload the Server Certificate but have come across a problem in uploading: We used the same cert file due the documentation stating: For certificate files which include both certificate and private key, such as .pfx, the same…
Good morning, I'm building a simple validation for a numerical field, where I'm using the "contains match" function. The output shows the right result (true) when looking in the grid view, however the output in the validation step is showing as a failure. (see screenshots below) Is there any issue on this configuration…
Hi there, Just want to check with you smart people what is the best way to remove duplicates from a list. Basically I am having a problem that some data is duplicating when coming to aperture from the Azure Data Lake and while we resolve this issue I wanted to create a function to deal with this duplicates so I can do the…
Can anyone shine some light onto why my duplicate store is matching these two addresses: Flat 11, Kylna Court, Wood Lane End, Hemel Hempstead, Hertfordshire, HP2 4BF Flat 22, Kylna Court, Wood Lane End, Hemel Hempstead, Hertfordshire, HP2 4BF The records are being standardised like this: The workbench explains the match as…
Good Afternoon, I'm using the below function to replace values in one column with another value that I've stored in a variable(all the columns are within the same dataset), and I'm able to change only one row. Is there anything I'm missing here? Many thanks in anticipation. Best regards, Marco
Is it possible to get External System Connection in Aperture for SAP, KAFKA, postgress, PWX ?
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…
Join us in London on Thursday, 10th July, for an exclusive in-person Data Governance Masterclass featuring Nicola Askham – The Data Governance Coach. This event is designed for data leaders like you who are looking to enhance their governance strategies, gain insights from industry experts, and connect with peers through…
