Steve Bernstein
- Total activity 27
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 7
Posts
Recent activity by Steve Bernstein-
"comment out" columns?
Is there a way to effectively "comment out" tabs in a workbook? I.e., leave them in place but not calc them. CONTEXT: I'm toying with changes in a workbook upstream, which break the downstream ta...
-
Easy deduping of a workbook?
I have a workbook with 14 columns of interest derived from a data source with a couple hundred columns. No rows are duplicated in the source, but in the subset of 14 columns there are duplicates. ...
-
Basic GROUPBYBIN question
The documentation for GROUPBYBIN is pretty sketchy. Here's my question. I have a column with days-to-an-event, integers. I want to bucket them into weeks-to-event, so I use groupbybin(@days-to-e...
-
How to get penultimate date in a sorted sequence of >1000 dates
I have sequences of transaction dates by buyer over a long period of time. To classify the buyers properly, I need three of those dates: the first date, the last date, and the penultimate (second...
-
Change chosen partitions in an existing workbook?
I have a workbook I started by choosing a subset of available partitions from a Datalink. I'd like to edit the partitions I originally chose. In particular, adding more partitions. I don't see h...
-
Expand a list to columns, one list element per column on the same row
I'm working on clustering a corpus of free text documents. On each row I have a document ID in the first column and an ordered element list of integer values in the second. In order to take advan...
-
How do I convert a list of tokens back into a single string (e.g., with a space as a delimiter)
I have converted a set of documents into a set of lists of strings so I could apply some the text & text mining functions to normalize the documents (e.g., correct common spelling errors). Now I w...