Hi,
I'm looking to use JSL to recode a column (creating a new column), based on user input. I have data that we get from a batch process, and we can identify each batch based on time, so I can clean up the data to look something like this:
What I would like to do is then prompt the user for input, in this case the lot number that corresponds to each batch, which would then be used to recode a new column with the lot number corresponding to the batch number. The final table would look something like this:
There is an additional caveat: The number of batches in a campaign is variable, anywhere from 1-16. The goal for this script is that it can be run on the manufacturing floor after the campaign of batches is complete, so looking to make it user friendly and easy to run. Any ideas?
