Invention Grant
- Patent Title: Join with format modification by example
-
Application No.: US15299363Application Date: 2016-10-20
-
Publication No.: US10546055B2Publication Date: 2020-01-28
- Inventor: Sumit Gulwani , Daniel Adam Perelman , Ranvijay Kumar , Euan Peter Garden , Chairy Chiu Ying Cheung
- Applicant: Microsoft Technology Licensing, LLC
- Applicant Address: US WA Redmond
- Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
- Current Assignee Address: US WA Redmond
- Agency: Alleman Hall Creasman & Tuttle LLP
- Main IPC: G06F17/24
- IPC: G06F17/24 ; G06F17/21 ; G06K9/00

Abstract:
A computing device is provided comprising a processor configured to select at least one pair of elements, including an element in a source column of the first table and an element in a target column of the second table. The processor may detect that the elements are in different formats. For at least one element, the processor may apply a predetermined mapping to a common format. The processor may modify at least one element to have the same format as the other, and may generate an example including the modified pair. The processor may programmatically generate a script that, when performed on the selected elements, produces a value consistent with the example. For the script with output matching the elements of the target column, the processor may convey the output for display, and may join the tables at least in part by performing the script on the source column.
Public/Granted literature
- US20180113848A1 JOIN WITH FORMAT MODIFICATION BY EXAMPLE Public/Granted day:2018-04-26
Information query