Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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