Solved

Hi community, We have a usecase to set a property's value automatically: based on several conditions that property gets a value. First we considered creating a desktop plan for this. Then we figured it would be preferrable to have this value set automatically, something that can possibly be accomplished by applying computed content. We have used computed content before, mainly for concatenating values (like described in Computed Content: Show attribute values based on existing attributes (ataccama.com)). But in this case we would need to define a case statement to define the conditions and determine the value. So the question is, does someone know if sql-like case stamenent can be implemented as computed content? And if so, can an example be provided? Thanks for your attention and kind regards, Albert

By using one url we imported multiple tables structure from workday into Ataccama. if we need to query any specific imported table in ataccama is ataccam will dynamically updates the API endpoints ?

Hello!Does anyone have experience using the Iterate tool within the Ataccama Desktop, when creating a workflow? I’ve found a couple of old community posts referring to it, along with the files they’ve used, but I can’t get it to work in my environment. see the following: Iterating rows of a table (Record-by-record - SQL Iterator) in a workflow Based on that post and my testing, it seems like the Iterate tool needs to call another workflow, so I’m calling another .ewf file that just has the Run DQC tool, which runs the .plan file. I’m able to succeed in running the .plan file from the Run DQC .ewf, however i can’t seem to get the Iterate tool to run, without getting Configuration errors, like the following: 12.03.2025 15:30:51 [INFO] Task 'Iterate' : failed with exception: com.ataccama.adt.internal.core.runtime.EwfConfigException: Configuration contains errors, exitingjava.lang.RuntimeException: com.ataccama.adt.internal.core.runtime.EwfConfigException: Configuration contains errors, ex

I am new to Ataccama and have some basics questions on how to start . is the ataccama one desktop and DQ analyzer are same tool or different ? i have installed ataccama one desktop but how to get trial license ?

i have installed ataccama one desktop but it is asking for license to execute anything. Can someone please help in providing free trial license.

Can the API response generated from the Data Quality Firewall feature be edited?

Hello community, I’m creating a Power BI source on Ataccama One and have a few queries: Is the built-in Power BI connection allow One to retrieve a Power BI datasets? Or this is strictly for only bringing the Power BI reports to One? The imported catalog items from this connection shows “0” number of attributes and “-” number of records (screenshots below). This is also presents in the the screenshot from the Ataccama support page (link). Is this behave as intended or am I missing anything here? Thank you in advance. Ben

Hi I have with great success been using your free desktop version of DQ Analyzer. But the license has run out. Last time I had this issue a new download and a re-installation solved it. I have tried to do the same, but it did not work. See issue “DQ analyzer windows version update” for further details. Any advice what to do?

The Business wants this date attribute validated. I don’t know why, it’s a key field and I assume managed by the DB. Nonetheless, I need to build a rule. But I think it’s strange that the Data Type is DATE while the date values are YYYY-MM-DD. I would expect to see DATE format data in the MM-DD-YYY HH:MM:SS AM format. I don’t know how to code it in the date functions since it doesn’t have the standard date format and it doesn’t work in any string functions. Any ideas?

I am making a DQ evaluation rule in ataccama one ui where I have to subtract each long value of catalogue item from its corresponding long value in lookup and if the difference is greater than 100, I want to raise that particular value as invalid sample, so far I am not able to achieve this, it would be great if anyone can help me with this.

Is there any way to get notification for data Profiling schedule failure with log details or successful.

We made changes into the clean operation of an entity. it will take effects for new transactions. How can we apply this to the current records that we already have into the database? We are exploring use a full reprocess of this entity: but we have some doubts about the setup. For example: What is the difference between a reprocess vs rematch checkbox? We tried to read the documentation but there is not detail explanation about it. Thanks in advance!

Hi I have a sub-query in Snowflake that is using the function of LISTAGG and PARTITION BY in multiple SELECT DISTINCT statements for example LISTAGG(DISTINCT TRIM(SUBJECT_REF), ' | ') OVER (PARTITION BY IDENTIFIER) AS EN_NUM_AGG, kindly see attachment to see the full SQL statement. Example of one of the subqueries: … en AS ( SELECT DISTINCT IDENTIFIER, ID, LISTAGG(DISTINCT ID, ' | ') OVER (PARTITION BY IDENTIFIER) AS ID_AGG, TRIM(SUBJECT_REF) AS EN_NUM, LISTAGG(DISTINCT TRIM(SUBJECT_REF), ' | ') OVER (PARTITION BY IDENTIFIER) AS EN_NUM_AGG, DQ_EN_CARD, LISTAGG(DISTINCT DQ_EN_CARD, ' | ') OVER (PARTITION BY IDENTIFIER) AS DQ_EN_CARD_AGG, DATA_SOURCE, ORIGINAL_SOURCE FROM db.schema.view1 WHERE subj_type = 'English' ) ... I wanted to replicate the same in Ataccama ONE Desktop using the Group Aggregator step, where I allocate each sub-query in one aggregation set with a condition of subj_type = '<value>' in the When condition. For each column in the SELECT DISTINCT subquery if it is a non-

We’re using version 15.4, mostly in the web tool. We’re trying to a subset of our input tables for testing before implementation the full table(s) in Production. We looked at using Data Slices, but we found that the ROWNUM feature of SQL met our purpose better: select * from (select * from dbname.tblname) where ROWNUM <=10000 Our primary question is how do we link/connect the SQL View and/or the Data Slice to the DQ Rule. We believe that it occurs in the Monitoring Project. I looked thorough the Ataccama online documentation, and the Community, but I can’t find the options to make these either of these connections. Any ideas! Thanks! Tim

Is there a way to quickly select only distinct rows in Ataccama One Desktop? (I now used a record descriptor and filter with Regex find(“.:.:1”, rd_column)

How do we activate Business Domain Analysis option in Profiling section.

Hi Ataccama Community, I want to upload a CSV file which is an export of DQ monitoring project results to SharePoint folder. I couldn’t see the Task SFTP upload file step in my OneDesktop (version 15.4). Is this step not available in the current version of Ataccama OneDesktop ? Or is there any work around to upload the CSV files to the Share Point server. CheersManidhar

Hi, I am attempting to connect to Collibra using the Collibra reader (refer to the page: Collibra Integration in Ataccama ONE Desktop 🏹). However, I am encountering the following error message when I execute the plan. Could someone please assist me? I have set up a server without a username/password because I don't need to enter a username/password when accessing Collibra.

Hi all, Suppose you have 2 tables that relate as 1:n. When joining the tables in a query without filtering, the result will be n rows. My requirement is to have just one row returned, with the values of the n-table shown as an array. In SQL Server you could use a query like SELECT p.PK_ONETEST, p.Name, p.Description, (SELECT c.Name FROM ODS.NTEST c WHERE c.FK_ONETEST = p.PK_ONETEST FOR JSON PATH) AS Children FROM ODS.ONETEST p ; resulting in My question is if we can also achieve this in one or more steps in One Desktop. Kind regards, Albert

Two records as same correation id and same version number one should process another one should error out how to implement this logic in ataccama

Hello, i am using a free version of the Data Stories , I cant seems to find where to upload or import dataset as seen from the demo --- Data Stories Demo does this free version not support creating a story , Dashboard or visualization ? if its does, is there something i’m not doing right

Hello, We recently started getting nested JSON event files with DAT file extension. We are getting an ‘Unknow Error’, when we try to import it. Can you help me in understanding, how nested JSON with .DAT extension can be processed in Ataccama. Thank you.

We recently updated the Data Sources connection, and all Catalog items that were using the old connection are no longer working in the monitoring projects. When I expand the catalog items, an error message appears: "You are looking at a deleted item." However, if I create a new catalog item and add it as an attribute in the monitoring project, it works perfectly fine. My question is: How can I update the existing catalog items to use the new connection? Do I need to manually recreate all these catalog items with the new connection, or is there a way to automatically switch all catalog items from the deleted connection to the new one

Hello Ataccama Community, I am trying to export the summary statistics of the DQ monitoring project? I wanted to have a csv file with the columns like Date of the test results execution, Data_Catalog_Name, Attribute Name, DQ rule name, Data Source, DQ dimension, Total Number of Records, Number of records passed, and Number of records failed. To begin with I have tried using DQ monitoring projects step in One Desktop and the DQ Monitoring project is failing if I enable this post processing plan. Not sure why it was failing after enabling the below post processing plan. Any help is much appreciated. Thanks in Advance

Hi guys, how did you check boolean date type in DQ rules? When I apply this rules it also make numbers, string, others value as correct.