- 专利标题: Join with format modification by example
-
申请号: US15299363申请日: 2016-10-20
-
公开(公告)号: US10546055B2公开(公告)日: 2020-01-28
- 发明人: Sumit Gulwani , Daniel Adam Perelman , Ranvijay Kumar , Euan Peter Garden , Chairy Chiu Ying Cheung
- 申请人: Microsoft Technology Licensing, LLC
- 申请人地址: US WA Redmond
- 专利权人: MICROSOFT TECHNOLOGY LICENSING, LLC
- 当前专利权人: MICROSOFT TECHNOLOGY LICENSING, LLC
- 当前专利权人地址: US WA Redmond
- 代理机构: Alleman Hall Creasman & Tuttle LLP
- 主分类号: G06F17/24
- IPC分类号: G06F17/24 ; G06F17/21 ; G06K9/00
摘要:
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.
公开/授权文献
- US20180113848A1 JOIN WITH FORMAT MODIFICATION BY EXAMPLE 公开/授权日:2018-04-26
信息查询