How to calculate reused rows or fields

[Anonymous]

Hi all,

I need to compare the below two tables for two customers,

and find the reued fields count.

Field Name has below conditions,

1. Data type

2. MIn Occurs

3. Max Occurs

4. M/C/O

5.Length

When 'Hapag Lloyd' is selected in the filter, we need to calculate the exactly reused fields based on all the above 5 conditions.

Values that are highlighted are varied values in the table. So when only fieldname is compared between two tables, the count will be 6.

If the fieldname is compared with all the above conditions, the count will be 1. I got this one.

But I need to find all the fields count for one condition matched, two conditions matched,three conditions matched and four conditions matched.

For example, field count exactly matched with one condition (Data type) from the above two tables is 1 (SCAC). Please help me to achieve this guys..

Thanks,

Siva

[vinieme12]

post a sample app or sample data and also post expected out with explanation; your explanation above is too confusing at least for me!

[Anonymous]

Thanks for the reply.

I have attached the sample data and I want the below mentioned output.

As per this data,

Total fields with all five conditions matched = 1

Total fields with only one condition matched = 1

Total fields with only three conditions matched = 3