Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

GRoup by and add back all records

amrutkasyap
7 - Meteor

I have a dataset with the following columns

 

 

RowIdFirsNameLastNamePIDKeyOther1Other2
1JohnDoe18177K1----
2John 2Doe 218177K1  
3John 3Doe 318178K1  
4John 3Doe 318177null  
5J2D218177null  
6J3D318178null  
7G1B119155K2  
8G2B219155K2  
9G2B219155null  

 

The requirement is

 

  • Group the dataset by column "Key"
  • Identify the unique "PID" value
  • Go back to the full dataset and search for all records with Unique PID value for each "Key" group
  • Add these records to the "Key" group

e.g.

group by Key "K1", RowId 1,2,3 will be selected.

PID 18177 and 18178 are the unique PID

Going back to the dataset 18177 has 2 additional rows Row 4 and Row 5

This needs to be added back to the group Key "K1"

 

I dont know if this is possible but wanted to check experts..

 

2 REPLIES 2
Kenda
16 - Nebula
16 - Nebula

Hey @amrutkasyap 

 

Is this what you're looking for?

Capture.PNG

amrutkasyap
7 - Meteor

Thank you, this should work..

Labels