First N records

Hi ,

I am new to the Alteryx. Challenge for me analysing the Survey responce which resides in CSV files.

I have responces for all 22 questions. my sample data for question 1 look like below in CSV file
rtaImage (1).png

Here I just want to filter only row 1 and send to a file ? Could you please suugest me a way to get only first 1 row (I am new please suggest the right tool)

Common Use Cases

Accepted answers

PaulT

Greetings! and welcome to the wonderful wide world of Alteryx!

The tool you're looking for is the Sample tool. This will allow you to select the First N records. The tool is defaulted to N=100, but can be changed to whatever value you want. There are also additonal options in the Sample tool which allow you to:

Take the Last N Records
Skip the 1st N Records
take 1 of every N Records
Random 1 in N chance for each Record
and First N% of records

Hope this helps!

Thanks,

Paul

All comments

PaulT

anujaymathur

Hey @PaulT,

Coming back to you after about 1 year of your solution.

I am using the sample tool to pull out first 1000 records from my file.

To take out this sample, the Alteryx still spends time in reading the entire file (>17Mn Records)

Is there a way I can stop the process the minute my first 1000 records are read, and save a lot of time.

Regards,

Anujay

Raghu_s

Hi @PaulT,

Am solving a similar problem where I need to limit overflowing record limits for a group in my data set.

EX:

GRP 1 has 10000 records - where I need only 6500 records

GRP 2 has 12000 records - where I need only 7500 records

GRP 3 has 19000 records. - where I need only 8500 records

Is there a way that we can parse this highlighted set of values for each group to the N field as in the case of sample tool ? Is there any other tool that can be combined to get this neatly?

For now, I have been manually writing filters to look up every group and then limit the records needed for every group. This gets difficult if I have 20+ groups and its time consuming as well.

Any thought would be appreciated.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703