Comparing two modules

Options
obernardini
obernardini Member, ALL USERS Posts: 3 New Contributor
in Planning & Modeling

Hi,

 

I am trying to make a module to compare two modules to see which values they share and which are missing from either. The values I’m comparing are 3 text line items and I wish to make 2 columns holding the results of if the value is missing from that module Boolean. I’ve tried using compare but I’m having issues as there are a different amount of rows of data in each module and the data doesn’t appear in the same order. I created a third module that includes all of the data from the two modules I am comparing but I am stuck on how to set up my comparison module and what formulas to use for the boolean/results column.

 

Any help is GREATLY appreciated!!!
Thank you!

Tagged:

Categories