Sample with filter

[akasubi]

I would like to take samples of my data with a filter applied on the samples.

E.g.

Take 40% sample where column = A

Take 40% sample where column = B

Take 20% sample where column = C

Is this possible?

[messi007]

@akasubi,

I suggest you to use Filter and sample and union them after:

Attached the workflow,

Hope this helps,

Regards

[akasubi]

Hi @messi007, thanks for your suggestion.

I do have a question though, doesn't the size of the sample change based on the number of values you get after your filtering? If value A has a lot more records in the data than value B, then taking 40% off of those will be different.

I'm looking to get a sample % (of each condition) of the total output.

Suppose my final output has 1000 records, 400 of those should equal condition A, 400 condition B and 200 condition C. Sorry should've been clearer.

[messi007]

@akasubi,

I have done a Batch Macro in order to batch in each condition

Attached a zipped workflow.

Hope this helps,

Regards,