Compare two tables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic Compare two tables in QlikView

Compare two tables