Is there a way to remove data duplication in ARIS Data Feed Editor? I have been trying to use the provided operators (conditional replace, filter row) but it seems impossible.
I need to combine 2 similar tables (same columns) that represent different datasets. When there is a duplication of data with only a difference in one column (e.g., status), how can I remove the duplication and keep only one row based on a specific condition?
Hi,
Thanks for the reply. That solution applies when using the same data feed, but in my case, both data feeds have the same columns but represent different datasets, particularly differing in the "status" column.
My goal is to have unique data by combining these feeds, but I'm facing limitations with the combine and filter row options. These limitations prevent me from keeping only one row when there is duplication. How can I achieve this given these constraints?