Start Free Trial

Alteryx Designer Desktop Discussions

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

Data Sampling

ManuelRodrigues
8 - Asteroid

Hi All,

 

I have around 35000 lines of data and i want to be able to pick a sample of 25 from that. could i please ask if there is a way of doing this say e.g. every 400th incidence?

 

Thanks

3 REPLIES 3
davidskaife
14 - Magnetar

Hi @ManuelRodrigues 

 

You have two tools that you could use, Sample tool or the Random % Sample tool. If you look at the tool example for the Random % Sample it has some information on the differences between the two tools, as behavior can be different depending on which option you go with

ManuelRodrigues
8 - Asteroid

what if the data repeats some lines and i want it to actually be representative of the whole data?

davidskaife
14 - Magnetar

You'd have to put something like a Unique tool prior to the sample selection to filter out any duplicated data

Labels
Top Solution Authors