turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Interactively select a column to perform an operat...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 28, 2015 8:36 PM
(618 views)

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Solution

It can be tricky to pull a column from a dialog and put into a column formula.

Here is one way to do it, based on your example:

Names Default To Here**(****1****)**;

dt = Current Data Table**()**;

cdlg = Column Dialog**(**sel = ColList**(**"Select Col", MinCol**(****1****)**, MaxCol**(****1****)))**;

f = Eval Expr**(**Log**(**Expr**(**cdlg**[**"sel"**][****1****])))**;

szz = cdlg**[**"sel"**][****1****]** << **get name**;

dt << **New Column****(**"Log of " || szz, numeric, continuous, formula**(**Name Expr**(**f**)))**;

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

It can be tricky to pull a column from a dialog and put into a column formula.

Here is one way to do it, based on your example:

Names Default To Here**(****1****)**;

dt = Current Data Table**()**;

cdlg = Column Dialog**(**sel = ColList**(**"Select Col", MinCol**(****1****)**, MaxCol**(****1****)))**;

f = Eval Expr**(**Log**(**Expr**(**cdlg**[**"sel"**][****1****])))**;

szz = cdlg**[**"sel"**][****1****]** << **get name**;

dt << **New Column****(**"Log of " || szz, numeric, continuous, formula**(**Name Expr**(**f**)))**;

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 29, 2015 3:08 AM
(508 views)