公开(公告)号：US11227104B2

公开(公告)日：2022-01-18

申请号：US14708146

申请日：2015-05-08

申请人： Informatica LLC

发明人： Mohan Sankaran ,  Andrew Comstock ,  Kiran Bagepalli ,  Gautam H. Mudunuri ,  Akin Dirik ,  Frank Beier ,  Mohini Wettasinghe ,  Ivan Chong

IPC分类号： G06F40/18 ,  G06F16/2455 ,  G06F16/25

摘要： A data profiling module receives user selection of spreadsheets, and the data from the selected spreadsheets is profiled. At least one matching column is identified among the spreadsheets selected. The data profiling module calculates a match metric for the at least one matching column, and unifies the spreadsheets into a single composite spreadsheet using the at least one identified matching column. A preview view of a composite spreadsheet is generated, visually indicating the at least one matching column, any non-matching columns between the spreadsheets, and the match metric for the matching columns. An action history module identifies spreadsheets for use in the procedure, and stores any action applied to the spreadsheets as a procedure template that can be applied to a plurality of other spreadsheets.