Sampling dataset

[Tid14]

H, I am working on a workflow where I have two input files one containes (prior 9 years data) other contains (current year data). After data massaging I have union both the files under same line and my data is in place.

Now I want to do a sampling using a union to get the best and worst quarters for each fund, which I am not sure about how to do it?

 

[atcodedog05]

Hi @Tid14 

Can you provide some sample input excel file and expected output it will help us get a better understanding of the usecase.

[DawnDuong]

hi @Tid14 

You can try using the Sample Tool (https://help.alteryx.com/20213/designer/sample-tool) via the following steps:

1) Sort your data by Fund and by the values that define "best/worst". Either ascending or descending would work.

2) Use a Sample Tool: to sample first 1 and last 1 row, used with the "Group by column" set on the fund name. 

Since the data is sorted, and the Sample Tool then picks the first and last (i.e. best/worst) for each fund (because Group by column is enabled).

Dawn.