Alteryx Forums  

Go Back   Alteryx Forums > Alteryx Forums > Alteryx Products Forum > Alteryx

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-20-2010, 12:34 PM
nharding nharding is offline
Administrator
 
Join Date: Apr 2009
Posts: 36
Default

The above suggestion is great and probably will work for you, but one other:

I am guessing you are reading from Excel. Since its not really a database format it has issues like this. You can create a named range in Excel that will then be available as a separate table. You can also specify a specifc range in Alteryx.

From the Alteryx help:

Specify Data Range of Input File: Identify the cells that contain the data to read into the module

Example: S:\temp\temp.xls|Sheet1$a2:b4 where A2 is the beginning of the data and B4 is the end. Keep in mind that Alteryx will handle A2 as a header field, as well as all of the columns in row A.

Another way you can do this is to create a named range in Excel and then that range will be an option when you browse to it in Alteryx.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro with Optional Input Margarita Wilshire Macros and Wizards 0 02-01-2010 08:07 AM
Using the Calgary Input Tool rhousebeta ALTERYX Tool Tutorials 0 07-28-2009 03:44 PM
Dynamic Input Tutorial scontes ALTERYX Tool Tutorials 1 06-22-2009 10:09 AM
Skipping Lines in input files Cconwell (Cconwell) Data Processes 1 05-26-2006 06:50 AM


All times are GMT -6. The time now is 10:41 PM.


Powered by vBulletin® Version 3.7.7
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.