In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
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: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Rows to column then match

MonaAlmutairi
8 - Asteroid
‎01-26-2025 02:50 AM

Hi everyone,

 

 

I have an example of the data I'm working on:

 

 

IDDateIs student?
101/01/2022Yes
101/01/2023Yes
101/01/2024Yes
101/01/2025No
201/01/2024Yes
201/01/2025Yes
301/01/2025No
401/01/2025No

 

 

 

I want to create a workflow, that give me an output like below:

 

IDYesNo
101/01/2022 
101/01/2023 
101/01/2024 
1 01/01/2025
201/01/2024 
201/01/2025 
3 01/01/2025
4 01/01/2025

 

 

I would appreciate your support.
Thanks 

Labels:
Reply
0 Likes
2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor
‎01-27-2025 08:42 AM

Hi @MonaAlmutairi you can use a Record ID and a Crosstab to achieve your desired results.

 

Screenshot 2025-01-27 164323.png

Crosstab_21012025.yxmd
Reply
binu_acs
21 - Polaris
‎01-27-2025 09:09 AM

@MonaAlmutairi another option using tile tool

image.png

 

cross_tab_27012025.yxmd
Reply
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All