Forum Discussion
learner03
Post Partisan
Post PartisanComparing 2 sheets and output in the report
I want to compare data of Table 1 to Table 2 and based on the comparision, I want the output . Table 1 is the main table and has all the fields populated. Table 2 will have some fields missing f...
ryan_mayu
Super User
Super Userhere is a workaround for you.
1. merge table and find out the exactly match records and filter out them.
2. use left ID merge table 2 again to get the data from table 2.
pls see the attachment below
learner03ryan_mayu Can you please show similar working on the dataset attached?
https://drive.google.com/file/d/1mlutRXI1oiQ5bg8AlBI0_g7q7vmLk-Rr/view?usp=sharinghttps://drive.google.com/file/d/1mlutRXI1oiQ5bg8AlBI0_g7q7vmLk-Rr/view?usp=sharing