My favorites | Sign in
Project Home Downloads Wiki
New issue   Search
for
  Advanced search   Search tips   Subscriptions
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
Status:  New
Owner:  ----

Blocking:
issue 239


Sign in to add a comment
 
Project Member Reported by thadguidry, May 29, 2010
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
Project Member #1 iainsproat
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
Project Member #2 thadguidry
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
Project Member #3 iainsproat
(No comment was entered for this change.)
Labels: -Priority-Medium Priority-Low Component-UI
Nov 19, 2010
#4 sogr...@gmail.com
"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
#5 russell....@gmail.com
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

Powered by Google Project Hosting