Okay, I have a source and let's say there are two fields and they look like this: Matching NumberType1234561123456211223311122332112233322334422233444 I need to be able to pull back one record per matching number and I want it to be the lowest numer type. So in the example above, I would want line 1, 3 and 6 How can I do this?

Hi @cowannbell , I guess it's the use case of Sample Tool. A sample workflow is attached. I hope this helps. Input Data RecordIDMatching NumberType11234561212345623112233141122332511223336223344272233444 Configuration of Sample Tool Output Data RecordIDMatching NumberType112345613112233162233442

Picked the lowest number

cowannbell

Okay, I have a source and let's say there are two fields and they look like this:

Matching Number	Type
123456	1
123456	2
112233	1
112233	2
112233	3
223344	2
223344	4

I need to be able to pull back one record per matching number and I want it to be the lowest numer type. So in the example above, I would want line 1, 3 and 6

How can I do this?

Developer

Accepted answers

Yoshiro_Fujimori

Hi @cowannbell ,

I guess it's the use case of Sample Tool.

A sample workflow is attached. I hope this helps.

Input Data

RecordID	Matching Number	Type
1	123456	1
2	123456	2
3	112233	1
4	112233	2
5	112233	3
6	223344	2
7	223344	4

Configuration of Sample Tool

Output Data

RecordID	Matching Number	Type
1	123456	1
3	112233	1
6	223344	2

SampleTool.yxmd

Yoshiro_Fujimori

The assumption is that the data is already sorted by Matching Number and Type (Ascending) before Sample Tool.

All comments

BS_THE_ANALYST

@cowannbell You'd need to use a Summarize tool.

You can use Group By in this tool and select the method of aggregation within the group.

For instance, you would group on Matching Number and use the aggregation method as the Minimum.

To see some example configurations of the Summarize I'd navigate to it within the Transform section in the tool palette, right clicking on it and "open example".

This will provide you with plenty of examples of how to configure the tool so you can teach yourself. This applies to 90% of Alteryx tools.

All the best,

cowannbell

Thank you for that information.

I have used the tool many times but not for this type of situation. Unfortunanly examples don't always help, as in the situation, the example did not help me. In the example I gave, I only showed two fields but I'm actually dealing with Multiple fields and I want to return all of the fields but only the rows where the type is the lowest for each matching number.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703