How to take N percent of rows by using Sample tool in Alteryx

This recipe helps you take N percent of rows by using Sample tool in Alteryx

Recipe Objective:-How to take N% of rows by using Sample tool in Alteryx.

Step 1:-

Open Alteryx Designer software.Here New workflow1 is by default available.

Step 2:-

Now go to the Favorite tab or IN/OUT tab where we can see a tool named as "INPUT DATA".

Step 3:-

Drag the INPUT DATA tool on the below side in the New Workflow1.Now go to the Configuration pane/window and click on the drop down available to connect a file or database.

Step 4:-

After this it will redirect us to the data connection window, here we have to click on files option, then click on select file option,it will then ask us to select a file from the folder, here we have selected a file named as"Office City Sales".Then select "Office City Sales" sheet from file and click on Ok.

Step 5:-

Then click on Run button or press CTRL+R, In the results workflow data will be displayed.Drag the Sample tool from the Preparation tab and connect it with the INPUT DATA tool.

Step 6:-

Then go to the configuration pane/window,Here we can see the Select Sample Type tab,then select option as "First N% of rows" specify "N=10", then click on run button to view the first 2 rows (10% of 18 records) in the results workflow.We can specify the value of "N" according to our requirement.

What Users are saying..

profile image

Ray han

Tech Leader | Stanford / Yale University
linkedin profile url

I think that they are fantastic. I attended Yale and Stanford and have worked at Honeywell,Oracle, and Arthur Andersen(Accenture) in the US. I have taken Big Data and Hadoop,NoSQL, Spark, Hadoop... Read More

Relevant Projects

Build Piecewise and Spline Regression Models in Python
In this Regression Project, you will learn how to build a piecewise and spline regression model from scratch in Python to predict the points scored by a sports team.

Learn How to Build a Logistic Regression Model in PyTorch
In this Machine Learning Project, you will learn how to build a simple logistic regression model in PyTorch for customer churn prediction.

Insurance Pricing Forecast Using XGBoost Regressor
In this project, we are going to talk about insurance forecast by using linear and xgboost regression techniques.

Learn to Build a Polynomial Regression Model from Scratch
In this Machine Learning Regression project, you will learn to build a polynomial regression model to predict points scored by the sports team.

Text Classification with Transformers-RoBERTa and XLNet Model
In this machine learning project, you will learn how to load, fine tune and evaluate various transformer models for text classification tasks.

FEAST Feature Store Example for Scaling Machine Learning
FEAST Feature Store Example- Learn to use FEAST Feature Store to manage, store, and discover features for customer churn prediction machine learning project.

Skip Gram Model Python Implementation for Word Embeddings
Skip-Gram Model word2vec Example -Learn how to implement the skip gram algorithm in NLP for word embeddings on a set of documents.

Learn to Build an End-to-End Machine Learning Pipeline - Part 1
In this Machine Learning Project, you will learn how to build an end-to-end machine learning pipeline for predicting truck delays, addressing a major challenge in the logistics industry.

Word2Vec and FastText Word Embedding with Gensim in Python
In this NLP Project, you will learn how to use the popular topic modelling library Gensim for implementing two state-of-the-art word embedding methods Word2Vec and FastText models.

Recommender System Machine Learning Project for Beginners-3
Content Based Recommender System Project - Building a Content-Based Product Recommender App with Streamlit