How to compare two tables and display the differences in a file or data grid.

1
How to compare two tables and display the differences in a file or data grid. These two tables correspond to one entity. Previously, I tried to compare using microflow loops, but there are a lot of objects and attributes, which is troublesome. Is there another way to quickly compare two tables?
asked
2 answers
0

Hi Zhang,

 

You will have to use a microflow to compare two list, but instead of using a loop action, rather use list operations. Please see the document https://docs.mendix.com/refguide9/list-operation/ 

 

I suggest the subtract function to show the differences. The after the subtract function gives you a list, return that list to your data grid.

answered
0

Hi, 

 

Instead of using loop, use the Union or Intersect action in list operation

answered