Compare fields with combinations

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

Guys,

I have two tables below with having fields for two customers,

Each field has 5 properties,

1. Data type

2. Min occurs

3. Max occurs

4. M/C/O

5. Length

1. Now I need to get the no. of fields which are exactly same for both the customers.

2. Need to get the no. of fields which are exactly matching along with those 5 properties and

3. Also need to get the no. of fields matched for all the combinations of 5 properties (i.e for two properties, 3 fields matched and for 3 properties, 2 fields matched, like that I need to get for all the possible combinations.

Could you guys please help me with script or expression wise code to achieve this in QlikView? or suggest any idea for this. I've also attached some sample data alongwith this.

Thanks,

Siva.

topic Compare fields with combinations in QlikView

Compare fields with combinations