Compare two excel files

0
Hello,         I have an use case to compare two excel files and come up with difference in file3. I tried  to create the microflow in Mendix and use the Intersect to compare the list1 and list2. but got an error as below showing. Can you please help me? Thanks!            
asked
2 answers
0

Hi Miya Qian

 

i think can you refer this its help you to solve this problem:

https://community.mendix.com/link/space/app-development/questions/134079

 

 

 

answered
0

Your current error is coming from the fact that objects File1 and File2 are not comparable with each other. They are simply different objects types.

 

What you *are* comparing is the text in those objects rather than objects. You might have to implement "intersect" functionality manually. That is loop through one list and find objects containing text in the other list; and the reverse the process.

answered