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
bhagbom
Level I

Using JSL to add column where value for all rows is fixed character string

I have a script that opens a .txt file and is adding a column that categorizes that set of data with by asking user to enter a string to categorize it. The file will be later joined with other files. I cannot seem to pass the string into all rows for the new column.

Once file is open:

New Window ("New Window",
< categorytextbox = Text Edit Box ( "Enter category here" ),
Button Box ( "OK" ),
);

::category = category << get text;

new column(
"Category",
Character,
Nominal,
Formula (::category),
);

Any help is appreciated. I've tried using Set Values function instead of formula with no success.
1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: Using JSL to add column where value for all rows is fixed character string

Try using different variable names for the value of category and the column. I've run into trouble in the past when my variable had the same name as one of my columns.

View solution in original post

2 REPLIES 2
pmroz
Super User

Re: Using JSL to add column where value for all rows is fixed character string

Try using different variable names for the value of category and the column. I've run into trouble in the past when my variable had the same name as one of my columns.
bhagbom
Level I

Re: Using JSL to add column where value for all rows is fixed character string

Thanks PMroz! It appears that solved the issue!