Hi,   Apologies for the delay in getting back to you with the promised demonstration. In the video link below you will see the application in use.   Link:         https://www.loom.com/share/73150b6a45654d789a6d040bb661cddf   From the video:            Using JMP defect data are collected from the inspection tool database.          JMP then summarises defect counts by Lot /Wafer and display them a line chart.          If there is a wafer of interest I simply hover over the defect count marker and a wafer defect layout is drawn using the previously collected data.            Having selected a wafer of interest I can then hover over a defect marker, on the wafer map, which will run an SQL query on the image database and display the defect image.    In this way there is no need to store  large numbers of defect images in the the data table. Just recall and review the few images of interest.   Thank you for your support in scripting.   - Philip   P.S.  I will present this application in  the Nordic JMP User Group on Oct, 9th 🙂 ... View more

Hi Nascif,   Thank you for your prompt response and great solution. This is exactly the functionality that I was looking for. I will try to build an example of the final application and share it with you.   Sláinte,   Philip ... View more

Hopefully I understood your task correctly. Under Graph, Scatterplot Matrix, you can enter all the paramters of interest )Param1, Param2, Param3,,,) into Y role and Group By category of interest, In your case TEMP. Hope this helps. - Philip ... View more

Thanks Jesper,   This is exactly what I needed.   Best Regards,   Philip ... View more

Hi Jesper, Thank you for your reply. Unfortunately I have been unable to script this action as I had hoped as I do not understand fully how your example script works. I am still a newbie in the scripting arena. In my case, using a data query script I have collected all the chip level data into a Data Table "Probe data".   I then construct the wafermaps using a Graph Builder script, after which I manually run the "Make into Data Table" command from the Graph Builder pull down menu in order to get the wafermap images into a new data table , Graph Builder Table   Could you please explain how your proposed script  fits into these steps?   Thanks,   Philip ... View more

Thank you Ian and Craig for your solution(s). This works beautifully If you are up to another challenge, .....  I was wondering if activated labels could be displayed when the Reference Line is placed on any point in any chart. Recall that there will never be a situation that points will occur exactly on the same x-axis location in my application. I my case, the labels would be operator written comments relating to testing, manufacturing or process monitoring. This is more "nice to have" rather than necessary but it would be very nice - Philip ... View more

Hi Ian, Thank you for  your fast response. This is exactly what I am looking for but I need it to work across 3 plots Using the "$SAMPLE_DATA/Big Class.jmp dataset I added a plot for :age but unfortunately when I try to set this up to work across 3 plots I have been unable to get it working. I can get 2 out of 3 working at any time. Would it be possible to add some comments to the script to explain what is the logic? My apologies for this inconvenience. In my case it would suffice that when  clicking on the center plot (:weight) the reference line would be drawn upwards and downwards covering all plots. Here is what I have done: Names Default To Here ( 1 ) ; dt = Open ( "$SAMPLE_DATA/Big Class.jmp" ) ; gb = dt << Graph Builder ( Size( 528 , 448 ) , Show Control Panel( 0 ) , Variables( X( Transform Column( "Row" , Formula( Row () ) ) ) , Y( : height ) , Y( : weight ) , Y( : age ) ) , ) ; :: exx = 1 ; gbfb3 = Report ( gb)[FrameBox( 3 )] ; gs3 = Expr ( gbfb3 << AddGraphicsScript ( PenColor ( "Red" ) ; PenSize ( 2 ) ; Mousetrap ( :: exx = x ; gbfb1 << removeGraphicsScript ( 1 ) ; gs1) ; VLine ( :: exx) ; ) ; ) ; gbfb1 = Report ( gb)[FrameBox( 1 )] ; gs1 = Expr ( gbfb1 << AddGraphicsScript ( PenColor ( "Red" ) ; PenSize ( 2 ) ; Mousetrap ( :: exx = x ; gbfb2 << removeGraphicsScript ( 1 ) ; gs2) ; VLine ( :: exx) ; ) ; ) ; gbfb2 = Report ( gb)[FrameBox( 2 )] ; gs2 = Expr ( gbfb2 << AddGraphicsScript ( PenColor ( "Red" ) ; PenSize ( 2 ) ; Mousetrap ( :: exx = x ; gbfb3 << removeGraphicsScript ( 1 ) ; gs3) ; VLine ( :: exx) ; ) ; ) ; gs1 ; gs2 ; gs3 ; The resulting plot looks like this: When I click inside the "age" plot, all goes well with the Ref. Line moving with the mouse across all plots. However when I click inside the "height" plot  the following happens: The Reference line moves through "height" and "weight" but not "age" Likewise when I click inside the "weight" plot  the following happens: The Reference line moves through "weight" and "age" but not "height" Could you please take a look? Thanks, Philip ... View more

Hi Yosef, Thank you for your input. I like the way in which you built the list for use in SQL scripts and am sure that I can use it when the need arises. In this particular case, the idea is to avoid the use of a wafer list in the SQL as it slows down the data acquisition when compared to the one wafer-at-a-time approach. Best Regards, Philip ... View more

Hi msharp, Many thanks for your input. I have now combined this "vertical joining" section of the script section into the main script and it works a treat Time required for data extraction has reduced to a fraction of what it was earlier and the possibility to script and automate the whole procedure allows me do this during the night  when our servers are under a lighter load. Best Regards, Philip ... View more

Hi PMroz, Many thanks for your support and your patience. Based on your input, as well as that of EricHill, Ron Horne and msharp I am now able to set up the nested SQL query as I had hoped. This method is directly transferable  to the more advance data acquisition task mentioned at the beginning of this post and it will save many hours of waiting for data to be returned from the server. I have learned a lot in this exercise and appreciate all your efforts. One last question.... Now that I have all the data  collected into separate data tables ( done to speed up data acquisition) is there a way, without having to save all the data tables, to perform a concatenation on all open tables so that I can more easily perform data analyses? I can do this already by saving all data tables and using JSL  to concatenate  them on re opening, but it seems silly to have to do it this way. Wishing you all a Happy Christmas, Philip ... View more

My apologies MSHARP if I have offended you in some way or other with my direct request for assistance. As I myself have already stated, unfortunately I am not an expert in JSL but I have managed to do quite alot based on the contents offered by this community. I did in fact attend a 2 day JMP JSL class but unfortunately due to its being organised by a local office in Europe for an American teacher with a very international class there were many technical glitches and a lot of time was lost over the 2 days, leaving a good deal of the material and workouts not being covered. I have had good feedback so far from other members of this community and am in fact working with JMP on a forthcoming tutorial based on an area where I have more knowledge and experience. On no occasion have I claimed any of the assistance offered by fellow members as my own work. I have been open in stating where the assistance is coming from and how great it feels to belong to such a supportive group where it is possible to climb the learning curve faster and further than in other communities. I can only hope that others share my sentiment and continue to support and teach the less capable. Sincerely, Philip ... View more

Hi Eric, Ron and PMroz, Thank you all for your input. Unfortunately my JSL competence is not at a level that I can take all your inputs and build a working script. I have not been able to ascertain the logic and sequence from your 3 inputs. I am still confused, but at a higher level My efforts are returning data only for the last wafer in my "wafers.jmp" list. How about I take a much easier example so that, at least I do not get confused. I have a list of wafers in a file named "wafers.jmp": XC6A49L410.1 XC6A49L411.1 XC6A49L412.1 XC6A49L413.1 XC6A49L414.1 XC6A49L415.1 XC6A49L416.1 XC6A49L417.1 XC6A49L418.1 I need to collect the WIPSTATUS of the listed wafers using the appropriate SQL:   SELECT WaferNR,WIPSTATUS   FROM "DISCSET"   WHERE WaferNR   = (  all wafers in the list above ) In order to do this I need to set up the connection string: "DSN=MEASdata;UID=USER;PWD=PASSWORD;DBQ=MDMANU.WORLD;DBA=W;APA=T;EXC=F;FEN=T;QTO=T;FRC=10;FDL=10;LOB=T;RST=T;BTD=F;BNF=F;BAM=IfAllSuccessful;NUM=NLS;DPM=F;MTS=T;MDI=F;CSR=F;FWC=F;FBS=64000;TLO=O;MLD=0;ODA=F;TSZ=8192;" I need to establish the variable "wafer_id"              '^WAFER_ID^'  ......... set up a loop to build the required SQL that will collect the required data, one wafer at a time   ........ open the database connection... run the "munged" SQL  ........ collect all data into one data table . ........ disconnect from the database ?? Using the simple example above could you guys please assist in constructing a script which could be tested so that I can attempt to work on the more advanced case myself. Best Regards, Philip PS   Please note that this is just a simple example to what I want to do, This data acquisition takes milliseconds while the advanced case currently takes from many hours to possibly days as I do not have the possibility to pull data for "one wafer at a time". ... View more

Thank you Jeff for your good advice. This particular data acquisition is indeed quite challenging and requires careful planning as data are retrieved from many DB tables containing many TB of data. 3 of our own DB administrators as well as 2 external companies have worked on its optimization. Hence the reason for seeking this " one wafer at a time" approach . This approach was recently demonstrated successfully, using the same SQL by Denodo but at the moment we do not have Denodo s/w yet available. Best regards, Philip ... View more