Interface Tools
Ranges
Select Records New
-100
Field1
Field1
ParseComplex
Field1
Warn
Field1_Matched
chosen = IF !isEmpty([Begin]) && !IsEmpty([Dash]) && !IsEmpty(End) && [Begin]<=[...
__RecordNum
1
Int64
6
0
[chosen]
Custom
[chosen]
Error
Input
Output
Horizontal
Question
Ranges
Question
Macro Output (75)
New Select Records
Select specific records and/or ranges of records including discontinuous ranges. Useful for troubleshooting and sampling.
Preparation
records, select, macro, range, sample, data, preparation category
Alteryx
Alteryx, Inc.
Alteryx, Inc.
Open Example
02 Preparation\Select_Records.yxmd
NoCondition
(Always Run)
UpdateValue
Ranges
Simple
Ranges
57/Data/r/c
Tab
Questions
Tab (48)
Label
Enter the numeric ranges of records to return. For Example:
-2
3
17-20
50+
Label (46)
TextBox
Ranges:
Ranges
-100
MacroInput
Input
Macro Input (74)
MacroOutput
Output
Macro Output (75)
Tab
Input
Tab (49)
Tab
Questions
Tab (55)
Tab
Input
Tab (56)
Macro
AlteryxHelp:Macro_SelectRecords
iVBORw0KGgoAAAANSUhEUgAAAKsAAACrCAYAAAAZ6GwZAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwgAADsIBFShKgAAAFJZJREFUeF7tnQuQHMV5xxEuXLYrVTgJu4sItoCkEsexyy6nKsRlx3FwIHG5Yic2ShmimzlJ3IkY7CCnAlYwSJElwDzKtpBuZk9IJ4F53aEHIIMkBAIhBLEkHkaIADICZCHZ6H16WNyJyfef/c63t/fN7szu7Ox0T/+rfnXS7UxP99f/6+2Z7uk+ycjIyMjIyMjIyMhIdXlj/uDfus/MtRU/n7O72vK2c23OcrtztruU/v1Ezna25C1nZ9529zEDhMc/S7+jz/3j/OPdpTiffn8N0kO6SB/X4QsaGYVQZ/GUwgT3XDLUZTnLKZLBNpDRDrH5mgtdB9eja7u4PvKB/HDOjLKuj4/vfX+hves8aulmEWvJLIdFI7UI5MfPF+UP+UR+OetGWVB+8vwCtWJTqPVaToborzRIyun38035Rzm4SEY66Yy2W/+Q+osd9NW+hn4OCiZQEGeQy9Mx9qLiaVxUIyU1ffrJ+XbnfGqFeunr9Lhc4Xrgl4/KifKi3BwBo7TrVLvnw9THu4oq8HWpYnUH5aYWd5ppbVOs0yfNHUeV9CPcVUuVmDUoFkfo57z8xK5zOERGrVZhQvfZ1G9bSBUz9HzTMBKKi7MQceKQGSWtM9rnfaT0TFLv/mhcIE6IV2kAwigR5cbP/T3/uajtHpUqxVAdxM2PH8WRQ2rUDFF/9CL6SntbqgRDVCiOFE8OrVFcKvVL3ZWjA26IgZWmPxuHxve+j/76p1J/K1XDoLrhx5fijHhz5I2iCI+i8pa7TgquoUlQvBF3rgKjMCrYXd+kv/T9YkANzcVyDuTb3Yu5KoyCNM7u+QD9dS8Qg2hIGGch6oOrxqhc/te+7W4aHTRDy7CczQXbOYuryAjy55Ta7h4xYIaWgnpB/XBVZVs5y51If8HvSoEypASqn9PauyZxlWVR3hiMpIjBMaQS1Ff23hXzn5+6PVJADGnHWZSZ57F4j4i+VnrlQBiUgOpP+/fBSo+mnBViAAxqQfV45oW3fJCrVi/hL5HuLB8UC25QEzKsfi1saYzffPXrSZ9GfVhvDDrlQiEN2kA3XTo8JaAW9Xq5gAatoHrmKldTBduZLBbMoClOB1e9WioNoZr3o7IE6lu5oVn/tWjbeUcqUFq5+JaHvAd+/kuRJU+/5v355YvE8+Ig6NrSsWnHn0ugyuQXPHuj/stmqSBp5uqfrveCNHjiPW/RYy+J58VB0LWlY5WA6l+JZ7CYBykWIOVUMyt08OhxvwWUzm0U7czq4yxkS6RTecudIGc8/dQyK/TMK7ua0h3Q06zoEnS1sTXSJSxTQ82/skv3hDHruwMnvDkrnhPPbwRdzer7IXXLF5VmUa0XM6wIYcwKvXPwqPeVHywT06gXbc0KyBepGuGiv6CpYkYVIsgw/cfe5X8N65EX3hTTqBetzQrwmncahAUSdHivP8gwD2/ezv8a1rHjA94Pep8R06kH3c0Kf6RiIQ2661slZVA1ggxz3jV9Yuv61juHvM9Nu1dMKyrat6w+ziq2TGuE98vljKlHNcPgGWul8Ox16dOvjUqnHrJhVqJV6xGM7Sx+iJr3N8VMKUg1w5x75d3etl0H+DfDOkwtbkfXI6PSikpWzAq/wDdsoeREF54hZUhVahmmY94j3vGBQf7tsF58c0/Dz14z07IS8A1bKBn5C/mWlgEXM6QiQYYZ6peO67jNW/bMNv7tsNAd6F71i1HpRSFTZiXfJLqgcc52XSkjKhNkmMu7H/vdMX/z3/d6O/Yc4k+Gtf/wbxsais2SWQH8w1Zqrvy1UjVclCLIMPh95XFSd6CRodismRX+SeRRlqoTVWoR1qwfI0Ou37qTPx0WhmJvXr5pxLFhyZxZgeX2sKWao7FtxY/ShbTcFSWsWcEFM5Z4u/cf4SOGtWv/4bqGYjNpVvJRU9eCpeZ7jnBRLYhiVnDNXRv4iJGqZyg2o2ZFd2AOWyteYec+uoBqG/OGJqpZ0R147vXf8FHDwlBs0DlBZNas5Cf4ii0Wn3K2c6VwMW2IalaAr/x9/cf4yGH9cveBSEOxGTarl7OL32OLxaTp008ms2q9F2o9ZgU/fuBZPnJYUYdiM21Wy90e6+bIlOAF0oV0ol6zfnrqT72tO/by0cOKMhSbZbMC+Iut1rioI6z90j/1mhVMunW1ODMr7FBs1s1K9LHVGhO2AqcugPbv/zdiVgzFBs3MCjMUm3Wzwl+xbDmft50O6QK60YhZQdDMrDBDsVk3a4kYVnPJWc4aOXG9aNSsIGhmVq2hWGNW9FudNWy5+lSY0JUnxw9KietGHGYNmplVayjWmBWQzybPL7D1oitvuZfICetHHGYFQTOzqg3FGrMO0UBXgJrmZXKi+hGXWQHOkboDQUOxxqwl4De2XkR1Fk+hBA5WJqgrcZo1aGZW0FCsMStjOYfgO3ZgeBUs9+/EBDUlTrOCoJlZ0lCsMesw8B1bMLxytjNbSkxX4jYrkGZmSUOxxqwjuI4tGF7U2X1SSEgpPvGd270/uyzc7P1mmDVoZlblUGwjZr3wxge9T11xh/iZkmC5oSjytwGynGNiYorwue/d49+VL167Vfy8kmaYFQTNzCofim3ErDPvfcYvJ8orfa4aGM2KtHV8wXL+SkpIFdBf3HOoZJDVz4ebDN0ss4KgmVlDQ7GNmBXlg/ZSeVFu6RjlaHM/y1asLWpVLxcTUYDxN67wv2aHlAazBs3MGhqKjcOsEMqN8kvHqQT8x1asLTq4KCWSdtAPxGhRudJgVhA0MwtDsRN+9DD/b6SkdCopNyuE8sexSkwrgf/YirVF/YYNUiJpZtod670T773HVTastJg1aGYWzDXvoef5fyMlpVNJpVkhxAHxkI5XAfiPrVhL3hg8nJUSSSsYdw9SWswKgmZmYUVCSVIalUhmHVK9r4angP5Qbw9gaRfh5FQydmJRbK3KlSazAmlmFm62JEnnV1LNrNBiig/iJJ2bZvDaP1syWKdZ7hekk9PGmZPn+3tF1VLazBo0M0uSdH4ltcwKIU6Il3R+WoEP2ZLBos6tJZ2cJs6ZssB7cuuvuCqqK21mBUEzsyolnVtJGLNCiBfiJqWRRuBDtmSw8rZzrXRyGP726l5v+t0bvIVrtng9j77k3bhsozd57upYg/QX317sPb999KhQkNJoVoB0pZlZ5ZLOqySsWSHEDfGT0mmE5tS7cy1bMlh0JzZfPlmm0O56E+es8l59ez+HZLRQKeg7ffI/bhfTCMtf/ued/kSQKEqrWYNmZpVLOq+SKGaFED/EUUorCs2ud/iQLRmsvOUskU6WOKvzNu/BjbX7jUM6dPS4Z/1kpZhWLb74/T5xFlMtpdWsIGhm1pCkcyqJalYI10Q8pfTCkEi9kw/ZksGi5vdx8eQK/mhyt7dp227OTnjhzvdSZ42YZhD/NHu5d+DIcU4hmsKaFY+V8NVVCX4vHR8X37z5Z+J1gXR8JfWYFcLoGeIqpVmN5OrdeZwtGayc5b4knzySu9b9H2cjuo4eH/A+H3J5nbYfr/QnLdersGZVlXrNCiGuiK+UbhBJ1XvOdreyJYNFfYWam1p8dfb9fPn6FWa1ve/MXxv4DDKsMJx5/vQlDYNW4VvFR0fw9RseoJb3Lu9Pv9Uj5n8IzA1AC43jh85FetJ1ooLyNaKBwRN+nKV8V5JUvQP4kC0ZLOor7JdOLuchYSOzeoQ9pqT0Aaa+CaOnqdXb+w57T72801v+v9u83qde8X/i//h92oU4I95SPZSTRL3/Dss5wJYMFg4ST2bQuW7ka7lc0nAg7jK7Hn6BjzBKUog74l9ZJ6DZ9T6KkGatul/Al2cu40s2rrUv7hiR9hmTuv1Wyah1unf9K349lNcLaGa9BzDAlgyWcNIIMNUtLr28Y++ItPueepU/MWql0GCU1wtoZr0HwZYMVq2WtZmZ/sLVvUr08XQW4o96KK8X0AKzhmhZa/RZm/118Jnv3um9tit4VMSoecJoFOJfWScg8W5AyD5r1acBSXS08SKd9FaoUfOEeFdbPC6VN1hhnrMm8Qjj7CkLvCe2hJtZVU2/2tPv3b52a8Pgq+vVnftF3t5bvevy7uCJUecgPek6UUH5GhXijHhL9VBOko+uQj1nDTOC9bXrknk4jKG95SHnfgYpiREsTOioJrwJIJ0XB42MYEGIL+IspV1JUvUOQo1ghZ0bkNSw2+ntRW/Bmi18ZnQZswYLcUV8pXSDSKreQ80NoL5CqFlXSU5kAT9cupFTiCZjVlmIp5ReLRKr9zCzrjCPUDxZIJGpYmVcuXhd5LkCxqwjhfj916J1YlphSaLe4UO2ZLAwQ1s6OYgkJ18DTJ2rNcO+XMasw0Lcwk49rEXz6z3MmwINvIOFCb0z7nnaf7UB3LRsk3cJBSfud3++8cMHxQUjJBmzloR4IW5SGo3SjHoP9Q6WKm+3Ynrcbw4e5aoIljGr58cJ8ZLOTyuh3m49o33eR6ST08hnr7rbN0I1JWHWL02/j68ma8XG18Xz4qCWWREfxEk6N82EWjdAtRVZ0B966a09XDWjlYRZ8XZnNS2JsI9rVKqZFXGJ4z6hBYRbkQWiOzGl1rrCTP2gGfNZNSviUesNhrQC/7EVawuruEmJpJmPdtzmrXx29HBgFs266rk3/HhIx6sA/MdWrC06WMn1WTFp+O4nR46wZM2sKL80eVol4D+2Ym2pvPI1nv/NLVtCMktmRbmDXktRCfiPrRhCncVTyN1HpIRUAcvZ4EW4LJgV5UR5pc9VA76LvBdWznLXSompxOXdj3kPb94ufhYnrTQryvft+Y+Jn6lJiAkslSKzzpITU4ugme9x0kqzJlG+JMnZzmy2YHhlbYfBRmilWXWjrh0G/b1bFVuuvVUYs8ZGf117t0LU2c3MrtiNYMwaD/AbWy+6qLPbISVqGIkxa2x0svWiKz95foEMOygkaijDmDUOyGfkN7ZefaKmeY2cuGEIY9bGyVnuo2y5+kUJdVYmrCPY5GzOiufq4s51L7MtZb2yc594XlikFVK0w3KmsOXq19iLiqflbOe4eAGNwFuXQ5sTp0mYeS/lVyfgL/iMLdeY8pZ7n3QR3fjHmUv914XTIiwqoeKGa5Ehf7HVGhf1Jy4QL6Ih/3rTilGbFbdC2Lcq7OITqpNr6/oHtloMmj79ZDLsdulCOvLv7qMtXXX7F2+84/3JpQvFvOkGfBX6rYCwokSvki6mK7jhaoVe332g6gJpupGznGlssfh0qt3zYUq8v/JiOvMTuhNPUrv2H276VkYpox++YovFq7zlzBEuqC2YyIy78SR08Ohx/3mtlA9tIT+xteLX6ZPmjqOLDIy6qMbgblx6tytO4QnEP19/v3h9jRko2M5ZbK3mKG+5PcKFtQZ35WF34Y4qrD0VdeM0PXAWsaWap8KE7rOp+a6674CO4O58S5X1CeoRnjhccdvj4vW0hvwDH7Glmiu6g1PuVe04wF067tbj0qze2hul6Qj8w1ZqvrDEEF1Q6RcK6wV3678+EH137kphgzQpfd2Bb+AftlIyylnu/0iZyQK4a8fde726b8OrWrwyXQ/wDVsoOY3tLH6ILvyWlKEs8C83PFDXPAKslpKVYdRK4Bf4hi2UrPLt7sVSprIC7uKjrMS9eduvvXEKL+vTMOQXtk4r5I3J284qMWMZ4YoFj4eaR7B1x15lF0qLA2pVV8MvbJzWCI8gcrZzWMpgVsBdfTXt3HvY+/TUO8Rzs4Dvj4ld57BlWqu85UyVMpkl3JXytvOY0P3X2RrvH02b+122Sgo0vvd9ectdL2Y0I+DuHnf55Try2wF/Qrd0fGawnKfgD3ZKOoRmnjKW6UUxcJe/mu72IUzg/voNzdlwQiH6qa/6x2yRdClnd7UJGc4UuNv/+Wu7/Qnc0udZAn5ga6RTedtZKGU8S6i+mG8sWG4PWyK9OvPCWz5I3YHNYgEM2YDqv2UP/6MK8xRztrtHLIhBa1DvTZ+nGrcK7V3nZWG9gSEwXwCrTy9cs8V/u+DGZRv9rSfj3l0xzaC+Ue9sAbVEBdB6NRc8rkpy31oFuJSrXk1R/+V6oVDKk/SO4KmH6pmrXGVh/oC7eFThFCaxPffVYXHLx/1jE0a4bLevooDKcte6kXttRRGmFWJdLSldRelL3QhVo/r4+N7301fFCqGwSvHV2fez7erXIy80f7ujRLDcn6FeuYr1Ej+DVdqwWCwtDp13TZ+YvjKQUVGfXLV6ym9hFe0S4KbqWEyrDN68fJN4DUXo07ZFHaVSH1a5m64vz1zGVmtca1/cIV5DARZr10etLW9MznZmC8FILZNuXc1Wa1wv79grXiPlXKfPXX8dKtjOZOrHKrFoRmbNikUpqJ64yrKtfFvx71WYS5DFboBfL+3O+VxVRhAmP9BfcKpna2XwButZ5SalJKVxds8H0j4fNjOPriy3B/XBVWMUJH89Ass5IAaxxXztOs0HBRD31r7fr578tWAtd50Y0Baj7XArxRtx5yowiiQ8j7WcqWlbl0C3iSx+fPG6dPaen8Yvf03YlK38os8UQWdVYmulZknUyl5ErcCbctCTR+XJ134cKZ4cWqNmCJMncpYzM2e7R6VKaBVf/H6fN+Oep/1XWsBNyzZ5l6TwtRbEDctOaj8JJU3iBY2L1Dpkbsn4uqA4IV6JL+RrNCzuzy6iCsnULjIRoLg4i0y/NEXi5YvmpO3JQasodZOcrtSs3mc0Wqde3PX71Ce7inhDqkTdQbnp635abFuiGyWg0ubIF1Br26t9v7ZUvj5/d+m4N+01SlZoZahCp1CLs4a+GgdHVbaSOIN+eahcphXVVPnJ8wu+cW13OVW6ahsn9/v5pvyjHFwkoywI7xH5yxxZ7ixiLbVUqdrbC/kp5cudhXxm570no9rqLJ5SmOCeS63XZWSUYs52NlArlswCyXQdXI+u7eL6yAfywzkzMgojbwzvBv4lvNpBhppBLV03GWop9RufoP9vyVvuTvp8n4/lniiZz/859Lud/nH+8e7S0vnODP+VHkq3NNMpw+82GRkZGRkZGRkZGWmhk076f8xjtBy89FyFAAAAAElFTkSuQmCC