Patent ID: 11893342
Assignee: BANK OF AMERICA CORPORATION
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 18:
19. The one or more non-transitory computer-readable media of claim 15, wherein executing the merge tables function comprises:
extracting frequency data for columns of the two or more tables in a vector FDATA;
inputting the vector FDATA into the columns with common values function;
based on execution of the columns with common values function on the vector FDATA, removing all columns for which values, common between the two or more tables are 1 and have a frequency of 1 in each of the two or more tables, resulting in a vector CCMERGE;
if the vector CCMERGE includes at least a single value:
generating, for each column of the vector CCMERGE, generate a binary mask;
for each binary mask:
extracting a vector CMROWS comprising a collection of corresponding rows from the two or more tables with the given binary mask applied;
for each element of the vector CMROWS that includes at least a single value:
using a split table function to define new versions of the two or more tables;
executing an outerjoin function to generate a new sub-table;
adding the new sub-table to the vector R; and
removing, from each of the two or more tables, rows belonging to the corresponding new versions of the two or more tables; and

outputting the two or more tables and the vector R.