How to find reused fields in two tables

[Anonymous]

Hi all,

I have two customers in a list box,

Both customers have some own fields each as shown below,

Customer - Cargo: (4 fields)

Customer - CPP: (5 fields)

1. When I select "Cargo" in the customer listbox, the "cargo" table (only Field Name) has to be compared with the "CPP" table and show the result as shown below,

I also want to display this field name count as 4.

2. For this same selection I also want it to compare the field names along with all the conditions (M/C/O,Datatype,Min,Max Occurs and Length) and show the result as below,

Because, for the fields Emp ID and Phone, two conditions (Max Occurs and length are changed). I also want to display this field name count as 2.

Please help me to achieve this friends.. It is so frustating. I have also provided sample data along with this.

Regards,

Siva.

• Sample1.xlsx

[Anil_Babu_Samineni]

Can you check this?

[Anonymous]

Thanks for the reply Anil. But you have loaded the data inline and not used any expression in it. I couldn't understand it.

[Kushal_Chawda]

For first condition count is 80 and for second condition count is 5 as per the data. Is it correct?