Alteryx Designer Desktop Discussions

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

Records not sampled

nwatzlaf
8 - Asteroid

Hi there,

 

This is probably a silly question but I need to know the answer.. Is there a way either in the sample tool or another tool that can show me all the records that were not selected in a random sample?

 

Thanks,

Natalia

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

Hi @nwatzlaf I mocked up a workflow that showcases how to answer that question. Let me know what you think?

AngelosPachis
16 - Nebula

Hi @nwatzlaf ,

 

One way I can think of is to assign a record/row ID in your dataset, then sample the data and then use a join tool, joining on that record ID. The records that are not in your random sample should fall out of your right output join, as shown below

 

Screenshot 2020-10-30 175457.jpg

 

Hope that helps,

 

Regards,

 

Angelos

Labels