Subscribe Bookmark RSS Feed

Formula for combining columns?

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

I would like to combine 2 numeric column data with a delimiter.

First I used cancat function with a third concat character but it seems the columns to be character. I used the char function but the result is obvious if you look at Column "Column".

Column Utilities "Combine Colums" make the thing perfectly but it does not implement the formula inside the column properties so no automation.

I have this script from the help menu but i can not adapt it as a formula and outside jsl option does not help me becuse of full automation.

Really appreciate any help

Combine Columns(

    delimiter( "," ),

    Columns(

        :Brush After Waking Up,

        :Brush After Meal,

        :Brush Before Sleep,

        :Brush Another Time

    ),

    Selected Columns are Indicator Columns( 1 ),

    Column Name( "When to Brush" )

)

8907_2015-06-11_14-59-15.png

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

For dates use the format command, with your favorite JMP date or datetime format.  Here's an example:

Format(:Publish Date, "m/d/y") || "," || Char(:Review Number)

3 REPLIES
pmroz

Super User

Joined:

Jun 23, 2011

Click on Cols > New Column

Name the column When to Brush

Click Column Properties > Formula

Double-click the red box that says "no formula"

Paste the following code into the code window:

char(:Brush After Waking Up) || "," ||

char(:Brush After Meal) || "," ||

char(:Brush Before Sleep) || "," ||

char(:Brush Another Time)

Click OK

Click OK

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Thank you PMRoz,

I am fine with it but I can't do my version where the data is numeric (date/time):

Here is the result when I

Char(:PUBLISH DATE.) || "," || Char(:REVIEW NUMBER)

8908_2015-06-11_15-36-24.png

Solution

For dates use the format command, with your favorite JMP date or datetime format.  Here's an example:

Format(:Publish Date, "m/d/y") || "," || Char(:Review Number)