Alteryx Designer Discussions

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

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

SOLVED

GRoup by and add back all records

Highlighted
6 - Meteoroid

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..

 

Highlighted
Moira

Hey @amrutkasyap 

 

Is this what you're looking for?

Capture.PNG

Highlighted
6 - Meteoroid

Thank you, this should work..

Labels