recode script

[#1]

I am trying to recode data (0 to .) after I pull it in from an sql server using the post querry scipt. I am getting an error at the end of my script. I am able to run the script through on the data table itself but would like this to happen automatically when I put in the data.

Here is my scipt.

Add Properties to Table(

{New Script(

"Recode",

Current Data Table() << Begin Data Update;

For Each Row( :purity_2 = Match( :purity_2, 0, ., ., ., :purity_2 ) );

For Each Row( :purity_3 = Match( :purity_3, 0, ., ., ., :purity_3 ) );

For Each Row( :purity_4 = Match( :purity_4, 0, ., ., ., :purity_4 ) );

For Each Row( :plus50_2 = Match( :plus50_2, 0, ., ., ., :plus50_2 ) );

For Each Row( :plus100_2 = Match( :plus100_2, 0, ., ., ., :plus100_2 ) );

For Each Row( :plus140_2 = Match( :plus140_2, 0, ., ., ., :plus140_2 ) );

Current Data Table() << End Data Update;)}

Here is the error message:

Unexpected end of input. Perhaps there is a missing "," or ")".

Trying to parse arguments of function "Add Properties to Table".

Line 60 Column 45:   Current Data Table() << End Data Update;)}►

Thanks,

[#2 · Accepted solution]

You're missing a close parentheses at the end.

Current Data Table() << End Data Update;)});

[#3]

That did not work, I got the following message.

Add Properties to Table(
{New Script(
"Recode",
Current Data Table() << Begin Data Update;
For Each Row( :purity_2 = Match( :purity_2, 0, ., ., ., :purity_2 ) );
For Each Row( :purity_3 = Match( :purity_3, 0, ., ., ., :purity_3 ) );
For Each Row( :purity_4 = Match( :purity_4, 0, ., ., ., :purity_4 ) );
For Each Row( :plus50_2 = Match( :plus50_2, 0, ., ., ., :plus50_2 ) );
For Each Row( :plus100_2 = Match( :plus100_2, 0, ., ., ., :plus100_2 ) );
For Each Row( :plus140_2 = Match( :plus140_2, 0, ., ., ., :plus140_2 ) );
Current Data Table() << End Data Update;
)}
) /*###*/;

[#4]

I am not really experienced in using the "Add Properties to Table()" however in reading the definition in the Scripting Index, it doesn't appear that what you are trying to do will work.  The following simplification of your script will work

Names Default to Here( 1 );
Current Data Table() << New Script(
	"Recode",
	Current Data Table() << Begin Data Update;
	For Each Row( :purity_2 = Match( :purity_2, 0, ., ., ., :purity_2 ) );
	For Each Row( :purity_3 = Match( :purity_3, 0, ., ., ., :purity_3 ) );
	For Each Row( :purity_4 = Match( :purity_4, 0, ., ., ., :purity_4 ) );
	For Each Row( :plus50_2 = Match( :plus50_2, 0, ., ., ., :plus50_2 ) );
	For Each Row( :plus100_2 = Match( :plus100_2, 0, ., ., ., :plus100_2 ) );
	For Each Row( :plus140_2 = Match( :plus140_2, 0, ., ., ., :plus140_2 ) );
	Current Data Table() << End Data Update;
);

[#5 · Accepted solution]

You need to send this as a message to your data table.  Here's one way to do it:

dt = current data table();

dt << Add Properties to Table(
{New Script(
"Recode",
Current Data Table() << Begin Data Update;
For Each Row( :purity_2 = Match( :purity_2, 0, ., ., ., :purity_2 ) );
For Each Row( :purity_3 = Match( :purity_3, 0, ., ., ., :purity_3 ) );
For Each Row( :purity_4 = Match( :purity_4, 0, ., ., ., :purity_4 ) );
For Each Row( :plus50_2 = Match( :plus50_2, 0, ., ., ., :plus50_2 ) );
For Each Row( :plus100_2 = Match( :plus100_2, 0, ., ., ., :plus100_2 ) );
For Each Row( :plus140_2 = Match( :plus140_2, 0, ., ., ., :plus140_2 ) );
Current Data Table() << End Data Update;
)});

[#6]

Edit: Ignore this, it is the same as Jim's post, above.

You can also send the New Script message directly to the table:

dt << New Script(
"Recode 2",
Current Data Table() << Begin Data Update;
For Each Row( :purity_2 = Match( :purity_2, 0, ., ., ., :purity_2 ) );
For Each Row( :purity_3 = Match( :purity_3, 0, ., ., ., :purity_3 ) );
For Each Row( :purity_4 = Match( :purity_4, 0, ., ., ., :purity_4 ) );
For Each Row( :plus50_2 = Match( :plus50_2, 0, ., ., ., :plus50_2 ) );
For Each Row( :plus100_2 = Match( :plus100_2, 0, ., ., ., :plus100_2 ) );
For Each Row( :plus140_2 = Match( :plus140_2, 0, ., ., ., :plus140_2 ) );
Current Data Table() << End Data Update;
);