cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
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

        );