I need to search a character column to look to see if each rows value contains specific strings and then create an indicator name/group accordingly in the new column (it will be searching for ~14 specific strings).  I'm pretty sure nested IF() would be pretty slow...  I have used Match() in the past when I want to match exact strings, but can I use wildcards? I tried * and % but to no avail:   Match( :columnOfInterest, "*StringA*", "String A", "*StringB*", "String B", "" ) I then tried to use Contains() within the Match() and still no luck:   Match( :columnOfInterest, Contains(:columnOfInterest, "StringA"), "String A", Contains(:columnOfInterest, "StringB"), "String B", "" ) I see that Contains returns a numeric so I also tried adding > comparison and even wrapping in NUM():   Match( :columnOfInterest, Contains(:columnOfInterest, "StringA") > 0, "String A", Contains(:columnOfInterest, "StringB") > 0, "String B", "" ) and   Match( :columnOfInterest, Num(Contains(:columnOfInterest, "StringA")) > 0, "String A", Num(Contains(:columnOfInterest, "StringB")) > 0, "String B", "" )   any help is greatly appreciated.  thanks! ... View more

I am trying to define a filter favorite that will scale as new data is added to my table:     Favorites( "Test_Favorite1"(Match( columns( :type, :name, :batchID ), Where( :type == "PM" ), Where( :name == "Weekly" ), Where( :batchID == {266, 268, 290} ) )) )     I would like to be able to specify what batchIDs to NOT include in the filter, that way as new batchIDs show up my filter will include them (but exclude the problem batchIDs that I have previously identified to exclude).  When I try to use the != operand, I get errors..  I also tried !== as well with no luck.     //example (include ALL batchIDs except for 268): <!-- Favorites( "Test_Favorite1"(Match( columns( :type, :name, :batchID ), Where( :type == "PM" ), Where( :name == "Weekly" ), Where( :batchID != {268} ) )) ) I don't see anything in the manuals/scripting guide.. is this possible? ... View more

New to Control Chart Builder, but I am liking it so far!  It appears that local data filters work with this platform (whereas control charts prior to CCB did not support them?).  Only issue I am having is that when a local data filter is used, the selection in the filter does not prompt a scale adjustment.  I notice the LCL/Avg/UCL are updated based on the local data filter selection, but the scale stays static. First question, is there a way to force a scale recalc?  If not, I thought of the following option: I can send scale changes via this jsl snippet when I generate the chart initially: <!-- SendToReport( Dispatch( {}, "area", ScaleBox, {Min( 0 ), Max( 500 ), Inc( 50 ), Minor Ticks( 1 )} ) ) --> but what I really need is for the scale to be set based on the local data filter selection. My thought is I could use the dynamically calculated LCL and UCL to adjust the Min and Max scale settings: Is there a way to access the UCL and LCL values dynamically(with each recalc)? If so, I could set them as variables and then use a formula to set the scale: <!-- //define variables LCLvar = reference to LCL value UCLvar = reference to UCL value //change scale based on those variables SendToReport( Dispatch( {}, "area", ScaleBox, {Min( LCLvar - 50), Max( UCLvar + 50), Inc( UCLvar-LCLvar/50), Minor Ticks( 1 )} ) ) --> Is this the right approach? or is there an easier way to accomplish the desired result?  thanks ... View more

I am familiar with the save script to data table command, but can I save a multipart script to one ​data table script? For example: my JSL script queries a database, then filters data, then creates a control chart.  When I save the script to the data table, I can send Save Script to Data Table to the filter, and again for the control chart.  This creates two table scripts respectively: What I would like to do, is use JSL to create a single table script which does both actions, that way an end user can save off the data table and later return and just run 1 table script to generate the output (filter+control chart).  I know how to manually create this (just edit one of the scripts and paste additional script portion into it), but I want the original script that is ran to do this. thanks in advance! ... View more

I have a list of specific values I am interested in identifying in my data set (specific values of the :MeasurementGroup column).  I created a new column called "Value of Interest?" with a formula to generate an indicator: either YES or NO dt1 << New Column( "Value of Interest?",   Character,   Nominal,   Formula( If(   :MeasurementGroup == "A", "YES",   :MeasurementGroup == "B", "YES",   :MeasurementGroup == "C", "YES",   :MeasurementGroup == "D", "YES",   :MeasurementGroup == "E", "YES",   :MeasurementGroup == "F", "YES",   :MeasurementGroup == "G", "YES",   :MeasurementGroup == "AA", "YES",   :MeasurementGroup == "BB", "YES",   :MeasurementGroup == "CC", "YES",   :MeasurementGroup == "ZZ", "YES",   :MeasurementGroup == "ABC", "YES",   :MeasurementGroup == "DEC", "YES",   :MeasurementGroup == "WSA", "YES",   :MeasurementGroup == "RSS", "YES",   :MeasurementGroup == "DVC", "YES",   :MeasurementGroup == "SFS", "YES",   :MeasurementGroup == "AAZ", "YES",   :MeasurementGroup == "ZZA", "YES",   :MeasurementGroup == "TTT", "YES",   "NO") ) ); My datatable has close to 1 million rows... and it seems to churn for a bit before populating.  Is there a more efficient way to acheive this same result? Any help is greatly appreciated! thanks ... View more

is this possible? I have an IR chart that was created via Analyze>Quality and Process>Control Charts>IR that uses the "Row Legend" option (right click on control chart, select row legend, then select variable to color data points by).      example: section "Change Marker Shape or Colors Based On Values" at the following link:  Use Markers I would like to switch to using Control Chart Builder (for various reasons) to generate this IR chart, but do not see a way to add a row legend? is this not supported yet or did it find a new home away from the right click menu? thanks in advance for any help! ... View more

I am creating a summary table and need to rename the columns. example: Summary(   Group( :RECIPE_FW ),   Mean ( :MTBW),   N( :MTBW ),   output table name("testOutput")   ); I found that I can reference the column # to rename: MTBW = Column(3); MTBW << Set Name ("MTBW (w/Outliers)"); nMTBW = Column(4); nMTBW << Set Name ("nMTBW"); My concern with this approach is that if more columns are added/inserted, these column(#) references will then rename the wrong column.  Is there a way to rename these columns within the Summary( ) portion? I tried the following and could not get it to work: Summary(   Group( :RECIPE_FW ),   Mean ( :MTBW)<< Set Name ("MTBW (w/Outliers)"),   N( :MTBW )<< Set Name ("nMTBW"),   output table name("testOutput")   ); any help is greatly appreciated! thanks! ... View more

I have a column with strings of varying length.  All strings have 1 semicolon separating the first and last part of the string. some strings with no 'periods': _______________;______ some strings with 1 period ______.______;_______ some strings with 2 periods ___._______._____;_________ I want to create a new column and populate it with the string of interest with the following conditions: IF a string contains exactly 2 periods, I want to remove everything from the second period up to the semicolon example:  "before1st.after1st .after2nd ;afterSemiColon"  would return  "before1st.after1st;afterSemiColon" ELSE, i just want to leave the string alone (no changes) I'm having trouble with this since the length of characters between each period can vary any help on the best way to achieve this would be greatly appreciated!  thank you! ... View more

I have been using 'output table name( )' to rename all of my summary tables, but this does not seem to work for with oneway( 😞 example: dt_Oracle<<Oneway(   Y( :Average ),   X( :TOOL_ID ),   Each Pair( 1 ),   Box Plots( 1 ),   Comparison Circles( 1 ),   X Axis Proportional( 0 ),   Grand Mean( 0 ),   By( :Rec ),   output table name("OneWay_"||tool||"_Average by Tool_ID_"||startDate||"_to_"||endDate||"_original"),   SendToReport(   Dispatch(   {},   "Oneway Plot",   FrameBox,   {DispatchSeg(   Box Plot Seg( 1 ),   {Box Style( "Outlier" ), Line Color( "Red" )}   ), DispatchSeg(   Box Plot Seg( 2 ),   {Box Style( "Outlier" ), Line Color( "Red" )}   )}   )   ) ); I'm guessing it does not work since Oneway( ) is not a table?  is there any way to rename the oneway( ) report using JSL? thanks! ... View more

the first portion of my script prompts the user to select 'Y' and 'By' variables.  It then outputs a datatable (lets call it "dt2"). the second half of the code relies on that datatable (dt2) that was generated after the user makes the selections and clicks OK. The problem I have is that the code continues to run once the window appears and is waiting for the user input.... so the 2nd half of the code has no datatable (dt2) to use so it doesn't output anything... i saw i can use wait( ), but this relies on a time value(in seconds), and I would like to script this so it doesnt continue until the user input is given in the first half of the code (thus generating the necessary datatable for the 2nd half of the code to execute). thanks in advance for any help/advice!! ... View more

I need to generate multiple fit y by x graphs. the number of graphs generated will vary based on the unique values in the 'RECIPE' column (used in the where clause) example: Oneway(   Y( :VALUE ),   X( :TOOL ),   Box Plots( 1 ),   X Axis Proportional( 0 ),   Grand Mean( 0 ), Where( :RECIPE == " RecipeA " ) SendToReport(generate etc etc etc RECIPE column could contain any number of unique values (" RecipeA ", " RecipeB ", " Recipe67283 ", etc...), thus generating any number of different y by x graphs for each unique RECIPE. when I copy the jump script, it just generates an additional block of code for each unique Where( :RECIPE == "__________") value.    I need this script to apply to any dataset , so i cannot specifically call out a string to match in the Where clause since these strings will vary based on the dataset! I tried using a wildcard (?) in the Where string and that didn't work: example Oneway(   Y( :VALUE ),   X( :TOOL ),   Box Plots( 1 ),   X Axis Proportional( 0 ),   Grand Mean( 0 ),   Where( :RECIPE == "?" ) SendToReport(generate etc etc I'm guessing the best way to accomplish this is to utilize Associative Arrays? If i use this code to create an array of unique RECIPES: uniqueRecipes = associative array(:RECIPE); and then try to grab a specific key value, say the first one: Oneway(   Y( :VALUE ),   X( :TOOL ),   Box Plots( 1 ),   X Axis Proportional( 0 ),   Grand Mean( 0 ),   Where( :RECIPE == uniqueRecipes <<First ) SendToReport(generate etc etc the above did not work.. but if i run just this line of code: uniqueRecipes <<First I get the correct string returned: "RecipeA" I am completely stumped.. maybe using associative arrays is just the wrong approach to begin with and there is an easier way?  My thought was that if i could use array values in the Where clause, then i could use some sort of loop to iterate through each of the unique values in the array... any help is GREATLY appreciated!  thank you for your time ... View more