|Issue 68:||Add UI to handle EDIT / JOIN Columns to perform basics of concatenation.|
|7 people starred this issue and may be notified of changes.||Back to list|
The proposed UI, "Edit Column / Join Several Columns" would allow simple column name input with separators to perform the concatenation function: cells["col1"].value + ", " + cells["col2"].value UI would expose the following input or clickable Add columns in an ordered concatenation such as: New column name, col1, col4, col2 which would perform a merge across col1, col4, col2 in that order and add results into "New column name"
Jun 1, 2010
I'm not following. Can't this be done already? Edit Column > Add Column based on this Column Use the GEL expression: cells["col1"].value + "," + cells["col2"].value Or do you want an entirely UI way of doing this? The workflow would have to be something similar to the following: Edit Column > Add Column by joining Columns Dialog box with multiple dropdown lists of columns to join together, and a textbox for the separator. I'm not convinced it would any quicker or easier.
Jun 1, 2010
Depends entirely on who the user audience is intended with Gridworks, I guess. But even Excel 2007 appealing to the masses has a little UI helper now to frame up this statement: =CONCATENATE(B:B," ",C:C) Look at FORMULAS / TEXT / CONCATENTATE.
Oct 14, 2010
(No comment was entered for this change.)
Labels: -Priority-Medium Priority-Low Component-UI
Nov 19, 2010
"I'm not following. Can't this be done already? Edit Column > Add Column based on this Column Use the GEL expression: cells["col1"].value + "," + cells["col2"].value Or do you want an entirely UI way of doing this?" In my case at least, this is only a partial solution. This approach succeeds where the columns in question have assigned values. Where some are null, however, the concatenation fails.
Jun 30, 2011
This can be done as described only if there are no nulls in the data at hand; things become considerably uglier if there are.
|► Sign in to add a comment|