Search
Close
Free Trial
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.- Community
- :
- Community
- :
- Participate
- :
- Discussions
- :
- Designer Desktop
- :
- remove duplicate records based on highest value in...
SOLVED
remove duplicate records based on highest value in one of the column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Preet2020
7 - Meteor
03-13-2024
05:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'd like to remove duplicate records based on ID. For the duplicated record, a check needs to be done in the BRANCH column and retain the record which has the highest value in BRANCH column. I also have unique records so those records should be retained in the output. Please advise
| INPUT | |
| ID | BRANCH |
| AF54WE | 7895433 |
| AF54WE | 67548 |
| NM765 | 45789 |
| HJLN67 | 9887654 |
| HJLN67 | 6321 |
| YG8790 | 1567 |
| YG8790 | 2238865 |
| OUTPUT | |
| ID | BRANCH |
| AF54WE | 7895433 |
| NM765 | 45789 |
| HJLN67 | 9887654 |
| YG8790 | 2238865 |
Solved! Go to Solution.
Labels:
- Labels:
-
Workflow
2 REPLIES 2
aatalai
13 - Pulsar
03-13-2024
05:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Preet2020 try this hope it helps
MilindG
12 - Quasar
03-13-2024
05:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Preet2020 One way to do this
Labels
-
AAH
1 -
AAH Welcome
2 -
Academy
25 -
ADAPT
82 -
Add column
1 -
Administration
20 -
Adobe
178 -
Advanced Analytics
1 -
Advent of Code
5 -
Alias Manager
70 -
Alteryx
1 -
Alteryx 2020.1
3 -
Alteryx Academy
3 -
Alteryx Analytics
1 -
Alteryx Analytics Hub
2 -
Alteryx Community Introduction - MSA student at CSUF
1 -
Alteryx Connect
1 -
Alteryx Designer
44 -
Alteryx Engine
1 -
Alteryx Gallery
1 -
Alteryx Hub
1 -
alteryx open source
1 -
Alteryx Post response
1 -
Alteryx Practice
145 -
Alteryx team
1 -
Alteryx Tools
1 -
AlteryxForGood
1 -
Amazon s3
139 -
AMP Engine
194 -
ANALYSTE INNOVATEUR
1 -
Analytic App Support
1 -
Analytic Apps
17 -
Analytic Apps ACT
1 -
Analytics
2 -
Analyzer
17 -
Announcement
5 -
API
1,060 -
App
1 -
App Builder
49 -
Append Fields
1 -
Apps
1,175 -
Archiving process
1 -
ARIMA
1 -
Assigning metadata to CSV
1 -
Authentication
4 -
Automatic Update
1 -
Automating
3 -
Banking
1 -
Base64Encoding
1 -
Basic Table Reporting
1 -
Batch Macro
1,301 -
Beginner
1 -
Behavior Analysis
221 -
Best Practices
2,456 -
BI + Analytics + Data Science
1 -
Book Worm
2 -
Bug
633 -
Bugs & Issues
2 -
Calgary
59 -
CASS
48 -
Cat Person
1 -
Category Documentation
1 -
Category Input Output
2 -
Certification
4 -
Chained App
240 -
Challenge
7 -
Charting
1 -
Clients
3 -
Clustering
1 -
Common Use Cases
3,460 -
Communications
1 -
Community
198 -
Computer Vision
49 -
Concatenate
1 -
Conditional Column
1 -
Conditional statement
1 -
CONNECT AND SOLVE
1 -
Connecting
6 -
Connectors
1,215 -
Content Management
8 -
Contest
6 -
Conversation Starter
17 -
copy
1 -
COVID-19
4 -
Create a new spreadsheet by using exising data set
1 -
Credential Management
3 -
Curious*Little
1 -
Custom Formula Function
1 -
Custom Tools
1,758 -
Dash Board Creation
1 -
Data Analyse
1 -
Data Analysis
2 -
Data Analytics
1 -
Data Challenge
87 -
Data Cleansing
4 -
Data Connection
1 -
Data Investigation
3,132 -
Data Load
1 -
Data Science
39 -
Database Connection
1,936 -
Database Connections
5 -
Datasets
4,673 -
Date
3 -
Date and Time
3 -
date format
2 -
Date selection
2 -
Date Time
2,936 -
Dateformat
1 -
dates
1 -
datetimeparse
2 -
Defect
2 -
Demographic Analysis
173 -
Designer
1 -
Designer Cloud
511 -
Designer Integration
60 -
Developer
3,726 -
Developer Tools
3,013 -
Discussion
2 -
Documentation
462 -
Dog Person
4 -
Download
920 -
Duplicates rows
1 -
Duplicating rows
1 -
Dynamic
1 -
Dynamic Input
1 -
Dynamic Name
1 -
Dynamic Processing
2,597 -
dynamic replace
1 -
dynamically create tables for input files
1 -
Dynamically select column from excel
1 -
Email
778 -
Email Notification
1 -
Email Tool
2 -
Embed
1 -
embedded
1 -
Engine
130 -
Enhancement
3 -
Enhancements
2 -
Error Message
2,013 -
Error Messages
6 -
ETS
1 -
Events
181 -
Excel
1 -
Excel dynamically merge
1 -
Excel Macro
1 -
Excel Users
1 -
Explorer
2 -
Expression
1,717 -
extract data
1 -
Feature Request
1 -
Filter
1 -
filter join
1 -
Financial Services
1 -
Foodie
2 -
Formula
2 -
formula or filter
1 -
Formula Tool
4 -
Formulas
2 -
Fun
5 -
Fuzzy Match
629 -
Fuzzy Matching
1 -
Gallery
606 -
General
93 -
General Suggestion
1 -
Generate Row and Multi-Row Formulas
1 -
Generate Rows
1 -
Getting Started
1 -
Google Analytics
143 -
grouping
1 -
Guidelines
11 -
Hello Everyone !
2 -
Help
4,203 -
How do I colour fields in a row based on a value in another column
1 -
How-To
1 -
Hub 20.4
2 -
I am new to Alteryx.
1 -
identifier
1 -
In Database
868 -
In-Database
1 -
Input
3,789 -
Input data
2 -
Inserting New Rows
1 -
Install
3 -
Installation
311 -
Interface
2 -
Interface Tools
1,676 -
Introduction
5 -
Iterative Macro
963 -
Jira connector
1 -
Join
1,774 -
knowledge base
1 -
Licenses
1 -
Licensing
212 -
List Runner
1 -
Loaders
12 -
Loaders SDK
1 -
Location Optimizer
54 -
Lookup
1 -
Machine Learning
233 -
Macro
2 -
Macros
2,541 -
Mapping
1 -
Marketo
12 -
Marketplace
6 -
matching
1 -
Merging
1 -
MongoDB
69 -
Multiple variable creation
1 -
MultiRowFormula
1 -
Need assistance
1 -
need help :How find a specific string in the all the column of excel and return that clmn
1 -
Need help on Formula Tool
1 -
network
1 -
News
1 -
None of your Business
1 -
Numeric values not appearing
1 -
ODBC
1 -
Off-Topic
14 -
Office of Finance
1 -
Oil & Gas
1 -
Optimization
663 -
Output
4,620 -
Output Data
1 -
package
1 -
Parse
2,132 -
Pattern Matching
1 -
People Person
6 -
percentiles
1 -
Power BI
199 -
practice exercises
1 -
Predictive
2 -
Predictive Analysis
832 -
Predictive Analytics
1 -
Preparation
4,710 -
Prescriptive Analytics
188 -
Publish
234 -
Publishing
2 -
Python
744 -
Qlik
36 -
quartiles
1 -
query editor
1 -
Question
18 -
Questions
1 -
R Tool
457 -
refresh issue
1 -
RegEx
2,137 -
Remove column
1 -
Reporting
2,163 -
Resource
15 -
RestAPI
1 -
Role Management
3 -
Run Command
506 -
Run Workflows
10 -
Runtime
1 -
Salesforce
251 -
Sampling
1 -
Schedule Workflows
3 -
Scheduler
378 -
Scientist
1 -
Search
3 -
Search Feedback
20 -
Server
538 -
Settings
768 -
Setup & Configuration
47 -
Sharepoint
488 -
Sharing
2 -
Sharing & Reuse
1 -
Snowflake
1 -
Spatial
1 -
Spatial Analysis
564 -
Student
9 -
Styling Issue
1 -
Subtotal
1 -
System Administration
1 -
Tableau
473 -
Tables
1 -
Technology
1 -
Text Mining
423 -
Thumbnail
1 -
Thursday Thought
10 -
Time Series
401 -
Time Series Forecasting
1 -
Tips and Tricks
3,855 -
Tool Improvement
1 -
Topic of Interest
41 -
Transformation
3,303 -
Transforming
3 -
Transpose
1 -
Truncating number from a string
1 -
Twitter
24 -
Udacity
85 -
Unique
2 -
Unsure on approach
1 -
Update
1 -
Updates
2 -
Upgrades
1 -
URL
1 -
Use Cases
1 -
User Interface
21 -
User Management
4 -
Video
2 -
VideoID
1 -
Vlookup
1 -
Weekly Challenge
1 -
Weibull Distribution Weibull.Dist
1 -
Word count
1 -
Workflow
8,648 -
Workflows
1 -
YearFrac
1 -
YouTube
1 -
YTD and QTD
1
- « Previous
- Next »
