John,
Looking at your problem, taking 376 rows of an uploaded dataset (ie. not available in a db) and creating arrays which contain rows 1-50, 51-100, . your best bet is to simply duplicate the master array and @DELROWS as needed to arrive the subset required. This will yield the fastest results. I would like to point out that Witango allows you to simply use a portion of an array (<@ROWS start=51 stop=100 array=my_full_dataset>) when you go to process your output, so the interim subset arrays might not be ultimately necessary. Since I don't know exactly what your end result is, this may or may not be pertinent advice. Robert _____ From: John Hotaling [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2008 4:30 PM To: witango-talk@witango.com Subject: RE: Witango-Talk: Array subset creation Hi Ben: Thanks for the feedback. Your method to create a subset array is pretty creative. I'm still trying to figure out how to make best use of the information. I have a few variables involved that are creating a challenge and may take another look at it today. For one, my initial "master" array is created from an uploaded file and therefore doesn't have a "0 row". This can be created manually I suppose, but the bigger challenge is that I don't have a match field like your sku. Does Witango provide a "0 column" reference (i.e. just a numerical index) similar to the "0 row"? I don't think it does, but if so, that would make this an easy task since I need to create my subset arrays strictly based on that value. For example, I need to pull records 1-50, 51-100, 101-150 etc. I was able to tackle this based on using the <@delrows> meta-tag, but I thought there would be a better way. My current approach processes pretty fast, so I guess having it as a fall back will work for now too. Thanks again, John ============================================================== John Hotaling [EMAIL PROTECTED] <http://www.AuctionAnything.com> www.AuctionAnything.com AuctionAnything.com, Inc. 509 S. Chickasaw Trail #168 Orlando, FL 32825-7852 Tel: 407.282.8568 Ext 160 Fax: 407.540.9574 ============================================================== _____ From: Ben Johansen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 6:29 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Array subset creation Ok, Robert G designed the Initial and I've used it all over <pre> 1. <@assign local$warrs <@filter domain$warrs "#parentSku = '<@var local$sku>' and #web_or_dash != 'D'">> 2. <@define local$sku_compare2 type=array cols=<@numcols array=domain$products> rows=<@numrows array=local$warrs>> 3. <@assign local$sku_compare2[0,*] <@var domain$products[0,*]>> 4. <@assign local$sku_compare2[*,sku] <@var local$warrs[*,sku]>> 5. <@assign local$warrProds <@intersect array1=domain$products array2=local$sku_compare2 cols=sku alpha>> </pre> let me explain (remember @intersect needs the 2 arrays to be identical in columns, so we are going to create an array from the small array) in this example we have a domain var holding thousands of products and a small array xref array for warranty skus line 1. gets the list of warranty skus based on a parent sku (so filter used here) this returns an array that has parentSKU and warrSKU columns line 2. creates a shell array using the domain$products structure line 3. takes the 0 row (column names from domain$products and populates our new shell line 4. populate the shell array with the warranty skus line 5. do the intersect using the sku column as compare. this is amazingly fast and no looping Ben On Mar 13, 2008, at 3:09 PM, John Hotaling wrote: Hello: I'm looking for the most efficient way to create a "subset" array from another "master" array (I'll need to create several subset arrays actually). However, I don't want to do any looping to create it due to performance concerns. I've used the <@delrows> meta-tag and that works fine but I am trying to simplify my approach some. I thought it may be easier using the <@filter> tag but I need to pull the subset based on the "index" row value (that's not a value currently in the array). I thought there might be a <@subset> type meta-tag but didn't see anything like that after reviewing the docs. Any input is greatly appreciated. Thank you. John ============================================================== John Hotaling [EMAIL PROTECTED] <http://www.AuctionAnything.com> www.AuctionAnything.com AuctionAnything.com, Inc. ============================================================== ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
