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
- :
- Problem joining tables, one has a formula and the other does not for the same co...

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

Problem joining tables, one has a formula and the other does not for the same columns

Jun 6, 2013 7:04 AM
(1129 views)

I'm currently trying to write a script that joins two different types of tables (one has digital information, the other analog). The first table has Date and Time as columns while the second does not. I created Date and Time columns using a formula based off of Raw Seconds but when I try to join them I have a problem. Either I have it copy the formula and I get an error every time it tries to apply and evaluate the formula on the rows from the first table or I don't have it copy the formula and I lose all the Date and Time values on the rows from the second table. Is there a way I can have it keep the calculated values from the second table without copying the formula? Once the tables are joined together, the data values will never be edited so I don't need to keep the formula around.

1 REPLY 1

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

Re: Problem joining tables, one has a formula and the other does not for the same columns

Never mind, I figured out a way to get around it. Instead of adding the time and date before joining by use of a formula, after joining, I searched for where ever the date was missing and had a function add the time and date on those rows.