cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Data_Mike
Level I

% in Column Name

Hello All,

 

There is an auto generated report which has the column name as % Adapter Bases. 

 

I want to update from this report, however when I use the column name it gives me an error since % is in the beginning. Is there any workaround to this?

 

Data Table( "all data" ) << Update (
With( dtv ),
Match Columns( :SampleID = :sampleID),
Add Columns from Update table( :% Adapter Bases ),
);

 

Thanks!

Mike

1 REPLY 1
jthi
Super User

Re: % in Column Name

 Try following syntax

:"% Adapter Bases"n

Scripting Guide > JSL Building Blocks > JSL Syntax Rules > Names 

-Jarmo