In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here

ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here

community Alteryx IO MyAlteryx

Toggle main menu visibility alteryx Community

en English (US)

English (US)
Français
Deutsch
日本語
Português
Español

Participate
Learn
Support
Groups & Events
Toolbox
Alteryx IO
MyAlteryx

cancel

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Search instead for

Did you mean:

Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Community
:
Community
:
Participate
:
Discussions
:
Designer Desktop
:
Count the data input coulumn

Count the data input coulumn

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

arkimp

8 - Asteroid

‎12-08-2022 07:57 AM

Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Notify Moderator

I have a Input file and in one column data is repeating.. Need to find the count of each data.

Input:

CAN

Output:

IN 3

US 2

IN 3

UK 2

CAN 1

Labels:

Labels:
Output

1 Like

All forum topics
Previous
Next

1 REPLY 1

Felipe_Ribeir0

16 - Nebula

‎12-08-2022 08:00 AM

Mark as New
Bookmark
Subscribe
Mute
Subscribe to RSS Feed
Permalink
Print
Notify Moderator

Hi @arkimp

One way of doing this

Count the data input coulumn.yxmd

0 Likes

Labels

Academy 6
ADAPT 2
Adobe 203
Advent of Code 3
Alias Manager 77
Alteryx Copilot 24
Alteryx Designer 7
Alteryx Editions 91
Alteryx Practice 20
Amazon S3 149
AMP Engine 250
Announcement 1
API 1,206
App Builder 116
Apps 1,359
Assets | Wealth Management 1
Basic Creator 14
Batch Macro 1,554
Behavior Analysis 245
Best Practices 2,690
Bug 719
Bugs & Issues 1
Calgary 67
CASS 53
Chained App 267
Common Use Cases 3,820
Community 26
Computer Vision 85
Connectors 1,424
Conversation Starter 3
COVID-19 1
Custom Formula Function 1
Custom Tools 1,935
Data 1
Data Challenge 10
Data Investigation 3,485
Data Science 3
Database Connection 2,216
Datasets 5,216
Date Time 3,226
Demographic Analysis 186
Designer Cloud 738
Developer 4,364
Developer Tools 3,525
Documentation 526
Download 1,036
Dynamic Processing 2,935
Email 927
Engine 145
Enterprise (Edition) 1
Error Message 2,253
Events 196
Expression 1,867
Financial Services 1
Full Creator 2
Fun 2
Fuzzy Match 711
Gallery 666
GenAI Tools 3
General 2
Google Analytics 155
Help 4,704
In Database 965
Input 4,290
Installation 360
Interface Tools 1,900
Iterative Macro 1,091
Join 1,956
Licensing 252
Location Optimizer 60
Machine Learning 259
Macros 2,858
Marketo 12
Marketplace 23
MongoDB 82
Off-Topic 5
Optimization 750
Output 5,246
Parse 2,325
Power BI 227
Predictive Analysis 936
Preparation 5,161
Prescriptive Analytics 205
Professional (Edition) 4
Publish 257
Python 853
Qlik 39
Question 1
Questions 2
R Tool 476
Regex 2,339
Reporting 2,429
Resource 1
Run Command 573
Salesforce 276
Scheduler 410
Search Feedback 3
Server 628
Settings 932
Setup & Configuration 3
Sharepoint 624
Spatial Analysis 599
Starter (Edition) 1
Tableau 512
Tax & Audit 1
Text Mining 468
Thursday Thought 4
Time Series 430
Tips and Tricks 4,183
Topic of Interest 1,126
Transformation 3,721
Twitter 23
Udacity 84
Updates 1
Viewer 3
Workflow 9,965

Alteryx Designer Desktop Discussions

Count the data input coulumn

Re: Unable to get an output

Re: Extracting the list of sheet names across mult...

Re: Chaining Apps

Re: Firm names parse

Re: Help with Multi-Row formula