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
- :
- concatenate / save and evaluate formulas

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

Highlighted

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

Created:
Aug 29, 2019 2:22 AM
| Last Modified: Aug 29, 2019 2:46 AM
(1517 views)

When manually concatenate two tables there is an option to “save and evaluate formulas” so the formulas in the new or appended date gets evaluated.

In JSL this option is not available only “keep formula” witch suppresses the evaluation.

`dt_1 << Concatenate(dt_2,Append to first table,save and evaluate formulas(1)); // this is not possible`

I know that you can use:

```
dt_1:mycol << Suppress Eval( 0 );
dt_1:mycol << Eval Formula(1);
```

To get tho the same result as with the manual option, but I must search and do this for each column with a formula.

Is there a hidden function or plans to include it in Concatenate as an option?

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

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

Keep Formulas does not supress the evaluation as far as I can tell.

Try this script and see that the formula in *Row No* is evaluated in the resulting table.

```
dt1 = New Table( "One Table",
Add Rows( 10 ),
New Column( "Row no",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( Row() )
)
);
dt2 = New Table( "Another Table",
Add Rows( 10 ),
New Column( "Row no",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( Row() )
)
);
Data Table( "One Table" ) <<
Concatenate(
Data Table( "Another Table" ),
Keep Formulas,
Create source column
);
```

-Jeff

3 REPLIES 3

Highlighted

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

Keep Formulas does not supress the evaluation as far as I can tell.

Try this script and see that the formula in *Row No* is evaluated in the resulting table.

```
dt1 = New Table( "One Table",
Add Rows( 10 ),
New Column( "Row no",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( Row() )
)
);
dt2 = New Table( "Another Table",
Add Rows( 10 ),
New Column( "Row no",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( Row() )
)
);
Data Table( "One Table" ) <<
Concatenate(
Data Table( "Another Table" ),
Keep Formulas,
Create source column
);
```

-Jeff

Highlighted
##

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

Re: concatenate / save and evaluate formulas

So my table has a formula, but it's not executed and is still supressed after the concat. I found earlyer a mention that it could be a time issue that the table hasn't time to evaluate the column and is somehow stuck. I will investigate further.

Highlighted
##

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

Re: concatenate / save and evaluate formulas

I could follow the datamanipulation and found the "problem"

I make a subset of an existing data table and clear all the data which locks the formula column and suppresses the evaluation.

Then filling the table with data, but the formula stays empty.

I concatenate multiple of the same tables (append to first table). If the master table has a supressed eval, concat tables are not evaluated either.

Allow evaluation of the subset solved the problem.

`dt_2 = dt << Subset(Output Table( "temp" ),Selected Rows( 0 ),Rows( [1] ),Selected columns only( 0 ),copy formula(1),link to original data table(0),Suppress formula evaluation( 0 ));`

Concat dt_2 has then formula evaluation enabled.

Article Labels

There are no labels assigned to this post.