Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Compare two tables

Hi all,

I have two customers in a list box,

Screenshot_2.png

Both customers have some own fields each as shown below,

Customer - Cargo: (4 fields)

Screenshot_4.png
Customer - CPP: (5 fields)

Screenshot_6.png

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.

Screenshot_5.png

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,

Screenshot_7.png

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.

0 Replies