Need to compare two different fields and generate report

[Former Member]

Hi,

I need to compare two different fields in different records which are from two different source records.

For example, I have field called Internatioal Material Number in one record from source system ERP1 and another filed called Material Number in another record from source system ERP2. I need to compare information in Internatioanl Material Number and Material Number are equal or not.

If Internatioanl Material Number equals to Material Number, matching strategy should be run on those records based on another filed called Description.

The above requirement should be generated in portal as report to users.

Please give your suggestions on achieving above requirement.

Thanks,

Narendra

[Former Member]

Hi Narendra,

As rightly suggested by Ravi, your requirement could be achieved using MDM workflows easily.

Workflow will compare the records and segregate them based upon success and failure of validation.

If validation is successful, feed those records to Match step and if validation fails for some records, then leave them as it is and end the workflow.

You need to add concerned records to workflow job and process accordingly.

These workflow could be triggered from Portal as well based upon certain conditions and user actions and Matching scores can be processed as per the requirement.

Other way would be to use JAVA APIs in Portal to develop all the above functionality through coding only. As rightly suggested, it will be more complex and will take more time to implement.

Thanks and Regards,

Ankush Bhardwaj

[Former Member]

Hi Naredra,

There can be more than one ways to achieve this requirement.

A simple method can be a MDM workflow with branch step.The Branch step would have this validation comparing the 2 desired fields.The records in TRUE would be the ones on which the matching strategy  would run on and the ones in FALSE be left as is.

The match step will be available on Portal.

The same can be achieved using a Java API which would be  more customisable solution.

Thanks,

Ravi

[Former Member]

Hi Ravi, Ankush,

Thanks for your reply. But here,comparision between two different records. Not on the same record.

Can it be done using validation?

Thanks,

Narendra

[Former Member]

Hi Narendra,

I get your point,and I think Validations may not be able to do this complex comparision.

Quoting you -

"For example, I have field called Internatioal Material Number in one record from source system ERP1 and another filed called Material Number in another record from source system ERP2. I need to compare information in Internatioanl Material Number and Material Number are equal or not.

If Internatioanl Material Number equals to Material Number, matching strategy should be run on those records based on another filed called Description."

So if we have 10 records from ERP1 and 10 from ERP2,this would require 10 * 10 comparision.

For such a requirement best fit would be a small code which would update a flag in the requisite records i.e.records which hold TRUE value.This code can be called using a custom button COMPARE (say).

This flag would serve as a input for Validation in simple MDM Workflow and rest could stay the same.

Thanks,

Ravi

[Former Member]

Hi Narendra,

I think your point is also valid. It would not be possible to check different fields of different records using validation. So you would need to go by Portal coding to implement these things.

Or, as a workaround, you may adopt below approach if you find it feasible:

• Create one Dummy field in Main table, just for matching purpose, called "Comparison Number"(say).
• You need to create assignment which will assign value of field "International Material Number" to this field if source is ERP1 or else it will assign the value of field "Material Number"  to this dummy field if source system is ERP2.
• For automatic execution of assignment, you can use MDM workflows.

• Then you can create one matching strategy containing two rules:
• One would compare values in field "Comparison Number" and set matching score accordingly.
• Second would compare values in field "Description" and set matching score accordingly.

• By running this strategy you will get some match score as per the situation(like same number different description, same description different number, same number and desc, different number and desc). So you should carefully use the desired score as per your requirement because matching score would be same for desired scenarios.

• So correspondingly you can display the report on Portal to user based upon the Matching score.

This should solve your purpose. You can try this workaround if you feel like.

Please let me know the results. Thank you.

Regards,

Ankush Bhardwaj

[Former Member]

Hi Narendra,

The best Solution would be to use the option as mentioned by Ankush in the above scenario and then making the use of the MDM Workflows to run the matching strategies and getting the results which could suit you best.

And If you want to avoid MDM Workflows usage for comparing the values in two different fields from different records JAVA API`s is the good option.

Regards,

Gaurav.

[Former Member]

Hi Narendra,

Can you please update close this thread and let us know your findings as well?

Thank you.