US 11,966,423 B2
Data preparation user interface with conditional remapping of data values
Randall Moss, Seattle, WA (US); Jingwei Qi, Kirkland, WA (US); Andy Yu-Lun Lin, Bellevue, WA (US); and Andrew Concordia, Seattle, WA (US)
Assigned to Tableau Software, Inc., Seattle, WA (US)
Filed by Tableau Software, Inc., Seattle, WA (US)
Filed on Feb. 11, 2022, as Appl. No. 17/670,407.
Application 17/670,407 is a continuation of application No. 16/228,680, filed on Dec. 20, 2018, granted, now 11,250,032.
Claims priority of provisional application 62/748,995, filed on Oct. 22, 2018.
Prior Publication US 2022/0164373 A1, May 26, 2022
Int. Cl. G06F 16/00 (2019.01); G06F 3/0482 (2013.01); G06F 16/22 (2019.01); G06F 16/25 (2019.01); G06F 16/28 (2019.01); G06F 16/901 (2019.01)
CPC G06F 16/287 (2019.01) [G06F 3/0482 (2013.01); G06F 16/221 (2019.01); G06F 16/252 (2019.01); G06F 16/9024 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for preparing data for subsequent analysis, comprising:
at a computer system having one or more processors and memory storing one or more programs configured for execution by the one or more processors:
receiving, in a data flow pane, user selection of a node that specifies an operation for a data set;
in response to the selection of the node, displaying data values for the data set corresponding to the node, in a grid in a data pane, the grid including a first column and a second column;
receiving a user input in the grid to edit a first data value in the first column in a first row of the grid, changing the first data value to a replacement data value;
identifying a second data value in the second column in the first row;
generating a rule that maps the first data value to the replacement data value for each row of the grid in which a data value in the first column matches the first data value and a data value in the second column matches the second data value;
inserting a respective node, into the data flow pane, that specifies a respective operation that performs the generated rule;
identifying one or more additional rows in the grid, other than the first row, whose data value for the first column matches the first data value and whose data value for the second column matches the second data value; and
updating, automatically in accordance with the generated rule, a respective data value in the first column in a second row of the one or more additional rows in the grid to the replacement data value.