Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
World Statistics Day was yesterday, but we’re celebrating all week long! This celebration means acknowledging the impact statistics has on our world. Who is your favorite statistician? Share with us who they are and why they top your favorites list.
Combining Multiple Columns with specific formatting
Jun 6, 2018 9:26 AM
| Last Modified: Jun 6, 2018 10:03 AM(1463 views)
I am stuck on a concatenate issue for two columns.
I have a full date in Column1 and a Unique Lot number in Column2. My goal is to combine column 1 and 2 with specific information. Here's example of what i have any what im looking for. I am using JMP 13, and was placing a formula directly into the column property instead of JMP Script.
Results(format i am looking for)
2016/01/22 12:00 AM
2015/06/23 01:00 AM
2017/05/24 02:00 AM
I am able to combine three column using:
The result i get is: [2016 1 12]
Which isnt exact format of interest.
I am looking to add the formula directly into a column instead of script. Any help would be appriciated.