What is the use of Record ID tool in Alteryx

This recipe explains what is the use of Record ID tool in Alteryx

Recipe Objective:-What is the use of Record ID 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.

Access YOLO OCR Character Recognition Project with Source Code

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 Record ID tool from the Preparation tab and connect it with the INPUT DATA tool.

Step 6:-

Then go to the configuration pane/window, By default the option of Record ID will be available under the Create new column tab, select the Starting value as "1".Now under the Options tab Type will be "Int32" and Position will be "First Column" which will be default available.Now click on run button to view the Record ID in the results workflow.

What Users are saying..

profile image

Ed Godalle

Director Data Analytics at EY / EY Tech
linkedin profile url

I am the Director of Data Analytics with over 10+ years of IT experience. I have a background in SQL, Python, and Big Data working with Accenture, IBM, and Infosys. I am looking to enhance my skills... Read More

Relevant Projects

Locality Sensitive Hashing Python Code for Look-Alike Modelling
In this deep learning project, you will find similar images (lookalikes) using deep learning and locality sensitive hashing to find customers who are most likely to click on an ad.

Build CNN for Image Colorization using Deep Transfer Learning
Image Processing Project -Train a model for colorization to make grayscale images colorful using convolutional autoencoders.

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.

Llama2 Project for MetaData Generation using FAISS and RAGs
In this LLM Llama2 Project, you will automate metadata generation using Llama2, RAGs, and AWS to reduce manual efforts.

GCP MLOps Project to Deploy ARIMA Model using uWSGI Flask
Build an end-to-end MLOps Pipeline to deploy a Time Series ARIMA Model on GCP using uWSGI and Flask

Azure Deep Learning-Deploy RNN CNN models for TimeSeries
In this Azure MLOps Project, you will learn to perform docker-based deployment of RNN and CNN Models for Time Series Forecasting on Azure Cloud.

Linear Regression Model Project in Python for Beginners Part 1
Machine Learning Linear Regression Project in Python to build a simple linear regression model and master the fundamentals of regression for beginners.

ML Model Deployment on AWS for Customer Churn Prediction
MLOps Project-Deploy Machine Learning Model to Production Python on AWS for Customer Churn Prediction

End-to-End Speech Emotion Recognition Project using ANN
Speech Emotion Recognition using RAVDESS Audio Dataset - Build an Artificial Neural Network Model to Classify Audio Data into various Emotions like Sad, Happy, Angry, and Neutral

MLOps Project for a Mask R-CNN on GCP using uWSGI Flask
MLOps on GCP - Solved end-to-end MLOps Project to deploy a Mask RCNN Model for Image Segmentation as a Web Application using uWSGI Flask, Docker, and TensorFlow.