ARIS User Group Meeting Wien (German)
Register
ARIS Process Mining in action - Live Demo
Register
ARIS Super User Group
Register

View all
Profile picture for user syarafuddinhilmi

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?

by André Vitor Oliveira
Posted on Tue, 08/06/2024 - 20:07

Hi 

For example you have Stream1 and Stream2 which uses the same Data Feed which will load the same columns, then select the Stream2 and click in 'column configuration' and disable the column.

column



BR
AO

1
by Syarafuddin Hilmi Ismail Author
Posted on Wed, 08/07/2024 - 04:16

In reply to by André Vitor

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?

 

 

0
by Syarafuddin Hilmi Ismail Author
Posted on Thu, 08/08/2024 - 10:38

Hi all, I have found the solution which is to use the RAQL which then enabled me to use the SQL query which makes it a lot easier. Thank you. 

0

Featured achievement

Question Solver
Share your expertise and have your answer accepted as best reply.
Recent Unlocks
  • BZ
  • Profile picture for user TEF_Bernd
  • ПЦ
  • CR
  • BH
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock