What is the use of Unique tool in Alteryx

This recipe explains what is the use of Unique tool in Alteryx

Recipe Objective:-What is the use of Unique 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"Coffee chain sales".Then select Coffee chain sales sheet from file and click on Ok.

Build a Multi Touch Attribution Model in Python with Source Code

Step 5:-

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

Step 6:-

Then go to the configuration pane/window, Column Names will be displayed there, select the option Product Type, then click on Run button so that the results workflow will be available with unique data, which are not having same text or numbers.Here 5 records are displayed which are unique.The Unique tool is having two output anchors, U-Unique and D-Duplicate, when clicked on "D" output anchor, the duplicate data can be seen,which will have same text or numbers.

What Users are saying..

profile image

Jingwei Li

Graduate Research assistance at Stony Brook University
linkedin profile url

ProjectPro is an awesome platform that helps me learn much hands-on industrial experience with a step-by-step walkthrough of projects. There are two primary paths to learn: Data Science and Big Data.... Read More

Relevant Projects

Recommender System Machine Learning Project for Beginners-4
Collaborative Filtering Recommender System Project - Comparison of different model based and memory based methods to build recommendation system using collaborative filtering.

Many-to-One LSTM for Sentiment Analysis and Text Generation
In this LSTM Project , you will build develop a sentiment detection model using many-to-one LSTMs for accurate prediction of sentiment labels in airline text reviews. Additionally, we will also train many-to-one LSTMs on 'Alice's Adventures in Wonderland' to generate contextually relevant text.

Multilabel Classification Project for Predicting Shipment Modes
Multilabel Classification Project to build a machine learning model that predicts the appropriate mode of transport for each shipment, using a transport dataset with 2000 unique products. The project explores and compares four different approaches to multilabel classification, including naive independent models, classifier chains, natively multilabel models, and multilabel to multiclass approaches.

Machine Learning project for Retail Price Optimization
In this machine learning pricing project, we implement a retail price optimization algorithm using regression trees. This is one of the first steps to building a dynamic pricing model.

Topic modelling using Kmeans clustering to group customer reviews
In this Kmeans clustering machine learning project, you will perform topic modelling in order to group customer reviews based on recurring patterns.

Detectron2 Object Detection and Segmentation Example Python
Object Detection using Detectron2 - Build a Dectectron2 model to detect the zones and inhibitions in antibiogram images.

MLOps using Azure Devops to Deploy a Classification Model
In this MLOps Azure project, you will learn how to deploy a classification machine learning model to predict the customer's license status on Azure through scalable CI/CD ML pipelines.

Build CI/CD Pipeline for Machine Learning Projects using Jenkins
In this project, you will learn how to create a CI/CD pipeline for a search engine application using Jenkins.

AWS MLOps Project for ARCH and GARCH Time Series Models
Build and deploy ARCH and GARCH time series forecasting models in Python on AWS .

NLP Project on LDA Topic Modelling Python using RACE Dataset
Use the RACE dataset to extract a dominant topic from each document and perform LDA topic modeling in python.