How to apply filter to the Date in Alteryx

This recipe helps you apply filter to the Date in Alteryx

Recipe Objective:-How to apply filter to the Date 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"Sales 2017-Copy".Then select "50 record orders" sheet from file and click on Ok.

Step 5:-

Drag the Filter tool from the Preparation tab and connect it with the INPUT DATA tool.The Filter tool will give output as true or false with the 'T' and 'F' output anchor.

Step 6:-

Then go to the configuration pane/window, Select Basic filter option, in that select column "Order Date <= Fixed", Select date from calendar as 2015-05-01 (yyyy-mm-dd format).Click on Run button, the results will be available with filtered data and will only display the records which are less than equal to or below 1 May 2015.

What Users are saying..

profile image

Abhinav Agarwal

Graduate Student at Northwestern University
linkedin profile url

I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More

Relevant Projects

Build Real Estate Price Prediction Model with NLP and FastAPI
In this Real Estate Price Prediction Project, you will learn to build a real estate price prediction machine learning model and deploy it on Heroku using FastAPI Framework.

Loan Eligibility Prediction using Gradient Boosting Classifier
This data science in python project predicts if a loan should be given to an applicant or not. We predict if the customer is eligible for loan based on several factors like credit score and past history.

Build ARCH and GARCH Models in Time Series using Python
In this Project we will build an ARCH and a GARCH model using Python

Recommender System Machine Learning Project for Beginners-2
Recommender System Machine Learning Project for Beginners Part 2- Learn how to build a recommender system for market basket analysis using association rule mining.

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.

Build a Autoregressive and Moving Average Time Series Model
In this time series project, you will learn to build Autoregressive and Moving Average Time Series Models to forecast future readings, optimize performance, and harness the power of predictive analytics for sensor data.

Time Series Analysis with Facebook Prophet Python and Cesium
Time Series Analysis Project - Use the Facebook Prophet and Cesium Open Source Library for Time Series Forecasting in Python

AWS MLOps Project for Gaussian Process Time Series Modeling
MLOps Project to Build and Deploy a Gaussian Process Time Series Model in Python on AWS

PyCaret Project to Build and Deploy an ML App using Streamlit
In this PyCaret Project, you will build a customer segmentation model with PyCaret and deploy the machine learning application using Streamlit.

Loan Eligibility Prediction Project using Machine learning on GCP
Loan Eligibility Prediction Project - Use SQL and Python to build a predictive model on GCP to determine whether an application requesting loan is eligible or not.