Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Sample Data Extraction

rushabh_shah
8 - Asteroid

I have a file which has millions of records. If i wish to see only a sample of i I can use the Sample node under Preparation, but it reads the entire data and then gives an output.

What if i want to see the first 10000 records from the file without entire file being processed?

Is there a way to stop reading the data when it reaches the required limit?

2 REPLIES 2
Federica_FF
11 - Bolide

Are you using a Input tool?

 

Look at the first option of the Input tool configurations window: "Record limits". You can set a X number and read only the first X records.

jdunkerley79
ACE Emeritus
ACE Emeritus

The Input Tool has the ability to limit the amount of records that are read in:

2016-07-26_12-02-19.jpg

Labels