All Forums  Origin Forum for Programming  LabTalk Forum  if condition for data extraction

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by maric001[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): 9.1 SR3 Operating System: Win7 Hi there! I have written a simple script to extract my data according to two ID values: win -o Samples { for (ii=0; ii<=9; ii++) { wxt test:="Col(C6)=$(ii)" iw:=[Samples]Samples! ow:=[Samples]productID$(ii); for (kk=0; kk<=5; kk++) { wxt test:="Col(C7)=$(kk)" iw:=[Samples]productID$(ii)! ow:=[productID$(ii)]measureID$(kk); }; }; }; Script works, but the values for "productID"(Col C6) and "measureID" (Col C7) can be different in different datasets, but always have a maximum range from 0-9 and 0-5, respectively. My script will produce a lot of workbooks/worksheets with no content at all, if or example only productID 0 and 2 are there, since it creates a worksheet for ProductIDs 0-9 all the time. How can i implement an if condition, that only extracts the data if the product ID is existent in the data? Same for the downstream process of extracting measureID? Thanks for your help guys! [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.