cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

Why do I get an error

The following script was copied after doing a manual concatenation:

Add Properties to Table(

    {New Script(

        "Source",

        Data Table( "Data_W_Nov_15" ) << Concatenate(

            Data Table( "Data_E_Nov_15" ),

            Data Table( "Data_W_Jan_16" ),

            Data Table( "Data_E_Jan_16" ),

            Data Table( "Data_W_Feb_16" ),

            Data Table( "Data_E_Feb_16" ),

            Output Table( "Combined" ),

            Create source column

        )

    )}

)

When I try to run it as a script I get the following error message. Why this error when didn't even change a single character.

Name Unresolved: Add Properties to Table in access or evaluation of 'Add Properties to Table' , Add Properties to Table(

    {New Script(

        "Source",

        Data Table( "Data_W_Nov_15" ) << Concatenate(

            Data Table( "Data_E_Nov_15" ),

            Data Table( "Data_W_Jan_16" ),

            Data Table( "Data_E_Jan_16" ),

            Data Table( "Data_W_Feb_16" ),

            Data Table( "Data_E_Feb_16" ),

            Output Table( "Combined" ),

            Create source column

        )

    )}

) /*###*/

In the following script, error marked by /*###*/

Add Properties to Table(

    {New Script(

        "Source",

        Data Table( "Data_W_Nov_15" ) << Concatenate(

            Data Table( "Data_E_Nov_15" ),

            Data Table( "Data_W_Jan_16" ),

            Data Table( "Data_E_Jan_16" ),

            Data Table( "Data_W_Feb_16" ),

            Data Table( "Data_E_Feb_16" ),

            Output Table( "Combined" ),

            Create source column

        )

    )}

) /*###*/

1 REPLY 1
ms
Super User (Alumni) ms
Super User (Alumni)

Re: Why do I get an error

It looks like you have copied a table script. The actual concatenation script is the second argument of New Script( ).  If you choose to Edit the table script you'll see the code in the dialog. Select all and copy the script there to get a "ready to run" copy.


This part should work as intended:

Data Table( "Data_W_Nov_15" ) << Concatenate(

            Data Table( "Data_E_Nov_15" ),

            Data Table( "Data_W_Jan_16" ),

            Data Table( "Data_E_Jan_16" ),

            Data Table( "Data_W_Feb_16" ),

            Data Table( "Data_E_Feb_16" ),

            Output Table( "Combined" ),

            Create source column

        );