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
- :
- 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
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

I am trying use JSL to interactively choose a column from a DT perform an operation on that column and place in a new column. I cannot get the syntax correct to execute the operation. Enclosed is my script and a sample DT.

Solved! Go to Solution.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 29, 2015 2:40 AM
(4497 views)

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

May 29, 2015 2:40 AM
(4498 views)

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
- Permalink
- Email to a Friend
- Report Inappropriate Content

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

Works Great. Much Appreciated