About Hari

Hari

Thanks for clear and nice explanation. Very helpful to learn how Column Formulas works. Thanks again.

Hari

Yes, perfectly fine. Much better and simpler way to do it. I was not aware that we can get quantile as well from summary table. I am implementing it the way you described. Apart from the quantile and top 10% data, Any comment what was wrong in my "for loop" ? Thanks for the help.

Hari

Hello, I have two questions - Ques1 -- I have a simple data (attached) and a script working fine but as long as I want convert it into a for loop. Not getting the right thing. AIM - I want the top10% resistance value for each current. My data is not symmetric, means number of data points for each current is different. In the same data there are only 7 current values and in real data, it can take 100s of values. Approach -- I am generating a Quantile table and then comparing my resistance value by 90% quantile value and adding an extra column 'Top10%'. Everything is working fine for sample data with 7 current values, but I need a loop for it. Can super users point me what is the mistake I am doing in my for loop, this will help to learn how implement for loops.? Any help ? Ques2 --What is the best way to get top 95% data ? Any help here ?

Hari

thanks. It works now.

Hari

hello, I have one line script but it is not working and log file is not showing any error. I have used same type of script / structure other place without any issue. Any help?

Hari · ‎06-11-2020

Working fine after this change. Hopefully will not face the issue again. Many thanks "Nelson".

Hari · ‎06-11-2020

Hello guys, I have a part of a script which some time does not work and throw an error -- " could not find column in access or evaluation of 'Column' , Column/*###*/("Core_BR.Res.(Ohms)") " In the script, I am just renaming columns and in fact, I thought it is related to the size of the table so I have included "Wait(0)" after each column rename command. But no good luck. Script is like this -- ---------------------------------------------- dt = Data Table( "STP_DATA" ); Wait( 0 ); dt = Data Table( "STP_DATA" ); Wait( 0 ); Column( "Core_BR.Res.(Ohms)" ) << Set Name( "Core_BR" ); Wait( 0 ); Column( "Rdr.Iso.(Ohms)" ) << Set Name( "Rdr_Iso" ); Wait( 0 ); Column( "Rdr.Res.(Ohms)" ) << Set Name( "Rdr_Res" ); Wait( 0 ); Column( "Rdr_Htr.Res.(Ohms)" ) << Set Name( "Rdr_Htr_Res" ); Wait( 0 ); Column( "TAD.Iso.(Ohms)" ) << Set Name( "TAD_Iso" ); Wait( 0 ); Column( "TAD.Res.(Ohms)" ) << Set Name( "TAD_Res" ); Wait( 0 ); Column( "Wtr.Iso.(Ohms)" ) << Set Name( "Wtr_Iso" ); Wait( 0 ); Column( "Wtr_Htr.Iso.(Ohms)" ) << Set Name( "Wtr_Htr_Iso" ); Wait( 0 ); Column( "Wtr_Htr.Res.(Ohms)" ) << Set Name( "Wtr_Htr_Res" ); Wait( 0 ); Column( "Wtr_I1.Res.(Ohms)" ) << Set Name( "Wtr_I1_Res" ); ------------------------------------------------------------------------------------------------------ And the error I get is --- ----------------------------------------------------------------------------- The thing is, I am not getting this error evrey time. Script works fine 7/10 times but throw error otherwise. If I active this table (by clicking it) and then run the script, it works 100%. Which means somehow my "dt= Data table (....)" is not refreshing oe recalling the table or somthing like that ! Any help. Thanks, Hari

Hari · ‎06-01-2020

Yes, it is working find. thanks.

Hari · ‎05-30-2020

Hi Nelson, Thanks for prompt reply. No they are not complex and yes, I am always looking for the 2nd segment of parameter as you described. Is there any other way to make it happen ?

Hari · ‎05-30-2020

Hello, I have a large set of data and I want to add a new column (Character) based on a pattern in another column. I have tested the script on small table, it is working fine but on my actual data set, it keep on trough error, see the attached image. No of rows in my data table is -- 1.8x10^6 and I am sure that is the issue. Is there any way I can make the evaluation bit slow in the script, hopefully that will work. Or any other idea/ suggestion. Any help.

Hari · ‎05-15-2020

Hello, I need help in stacking script. I have a table which has 80 columns and morethan 100k rows. I want to make a new table, which should have 6 columns in a pair like "data" and "label" in stack table. My stacked column is based on the colum name, so say in 80 columns, 30 has one type of information, 15 has another type of information and rest 35 have 3rd type of information. I want to stack the columns based on their data type. Please see the attached files. I can do that by making 3 different tables and then update the tables and make them one. But I was wondering if there is any smarter way to do it? Any help? Thanks.

Hari · ‎02-13-2020

This is really very helpful. Thanks.

Hari · ‎02-13-2020

Thanks Paul, There few simpler one, I was able to do it but this was the one. which gave me some trouble. Next time if I found any issue, I will get back to you with more details. Do you have some reference / link to share with me /us on Regex with good examples ? That would be very helpful. Thanks again.

Hari · ‎02-12-2020

hello, I need just some help to use Regex function -- String is like -- "Fine.2020.Optional.(Not)" Required -- "Fine_2020_Optional" I have tried couple of combination, but not able to get the result in one regex. I am using this type of Regex in my for loop script. Any help ? Thanks.

Hari · ‎02-04-2020

It worked. Many Thanks.

Hari · ‎02-03-2020

Hi TxNelson, In the script, if I comment out -- Column( colNamesList[theColumn] || " PASS/Fail" ) << delete formula; it is running fine. Just a query -- are we not deleting the column formula, even before we are getting our column? As our column will be complete once we will substitute the values of LSL and USL and we are doing in in the next line of For loop ? colNamesList = dt << get column names(string,continuous); For( theColumn = 1, theColumn <= N Items( colNamesList ), theColumn++, Clear Symbols( specs ); specs = Column( dt, colNamesList[theColumn] ) << get property( "Spec Limits" ); If( Is Empty( specs ) == 0, /*show(colNamesList[theColumn] || " PASS/Fail"), Wait (1); */ Eval( Substitute( Expr( dt << New Column( colNamesList[theColumn] || " PASS/Fail", numeric, CONTINUOUS, FORMULA( If( __LSL__ <= __col__ <= __USL__, 1, 0 ) ) ); /* Column( colNamesList[theColumn] || " PASS/Fail" ) << delete formula;*/ ), Expr( __LSL__ ), specs["LSL"], Expr( __col__ ), Parse(":" || colNamesLIst[theColumn] ), Expr( __USL__ ), specs["USL"] ) ) ); );

Hari · ‎02-03-2020

Whatever the wait time I am putting, it just evaluate only first column and through the same error. But, if I split and run it in two parts -- it is fine ! No idea why ?

Hari · ‎02-03-2020

dt << rerun formulas; and wait (0) - none of them is working for me. But yes, if I split my code in two runs -- it is working fine. Any other suggestion ?

Hari · ‎02-03-2020

Hi, Yes it is working if I am running code till manage spec limit first and then the rest of it, And adding show(colNamesList[theColumn] || " PASS/Fail"); does not make any difference. Code is still not running in one go, even after adding this line. Is there any way I can force to evaluate manage specs limit part first and then move further or can I put some wait (say - 2 sec) commend before going into the for loop ? Thanks.

Hari · ‎02-03-2020

Hi, I did that check and made sure that LSL and USL both should be there in specs table. In fact, I also start the For loop -- the Column = 10 where I knew that from column 10th onward, I have specs limits in the table, though it should be taken care by Is Empty statement. Nothing worked. Thanks.

Hari · ‎02-03-2020

Hi Nelson, I an getting following error in the script you send me on Friday. Any help Also why do we use "__" in specs limits like LSL. I was trying to find answer in jmp script guideline but could not understand much. Thanks.

Hari · ‎01-31-2020

Hi, Many thanks, Yes, that is what (reading Scripting Guide ) I am doing now a day. 🙂

Hari · ‎01-31-2020

Hello TxNelson, I need similar solution and I was trying to follow the one you have provided but not able to get my results. Could you please help me -- I have two tables -- one is data table and other is specs table. I need to compare data in main table with the specs in specs table and put it into a new column as 1 (pass) and 0 (fail). Any help ?

Hari · ‎01-31-2020

dt = Data Table ("Table_B"); dt2 = Data Table ("Table_A"); dt3 = dt2 << Manage Spec Limits( Y( :BVIA_RES, :RDR_RES, :TAD_RES, :WELGR_RES ), Load from Limits Table("Table_B.jmp"), Save to Column Properties (1) ); dt3 << close window; Hi Tonya. Everything is sorted out. Many thanks

Hari · ‎01-30-2020

Hi Byron, I did it, but still the error is same. Any other suggestion ? Thanks.

Hari · ‎01-29-2020

Data table -- Specs Table -- Script using -- dt = Data Table ("Specs_Limits"); dt = Data Table ("Table_A"); dt << Manage Spec Limits( Y( :BVIA_RES, :RDR_RES, :TAD_RES, :WELGR_RES ), Load from Limits Table(Specs_Limits) ); Error --- Any help ? Name Unresolved: Specs_Limits in access or evaluation of 'Specs_Limits' , Specs_Limits/*###*/Exception in platform launch in access or evaluation of 'Manage Spec Limits' , Manage Spec Limits(/*###*/Y( :BVIA_RES, :RDR_RES, :TAD_RES, :WELGR_RES ), Load from Limits Table( Specs_Limits ) ) In the following script, error marked by /*###*/ Manage Spec Limits( Y( :BVIA_RES, :RDR_RES, :TAD_RES, :WELGR_RES ), Load from Limits Table( Specs_Limits/*###*/ ) ) Manage Spec Limits[]

Date Registered	‎01-29-2020 10:50 AM
Date Last Visited	Friday
Total Messages Posted	26
Total Kudos Received	3

Online Status	Offline
Date Last Visited	Friday