Choose Language Hide Translation Bar
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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!
Article Labels

    There are no labels assigned to this post.