Finding the best indices to merge two(or more) excel sheets on

38 Views Asked by At
  • The platform I am working on has different sources of data collection.
  • Sources: E-commerce platform, Payment Merchants(some bank tie-up), In-house loyalty program and Customer Demographics

  • Now we're trying to solve the Merge and Purge problem. But in order to do that we need to integrate the data into one place.

  • The column have different names and there is no unique id to merge the data on. We need to create custom keys like Name + DOB + some other criteria.

  • We want to automate the process of finding the best keys to merge the data on.

  • I have tried looking for research papers targeting this problem but couldn't find much. My only luck has been Paxata

  • Could someone just point me in the right direction as in where to start?

0

There are 0 best solutions below