Advance filtering logic, needs help.

Hi,

I have a databases of codes that I would like to filter out but I'm currently not too sure how to develop the logic.

From the sample that I have attached, I would like to find the [JE code] that relates to 110, so at this case its 9540, 9542 and 9544. But at the same time, I need to extract the rows of the item out also, regardless of the GL code.

Can anyone please help me to figure out how can I do it in Alteryx?

Thanks!

Sample.xlsx

Datasets

Accepted answers

unknown

Hey @terrellchong!

I'm not too sure what you mean by codes you need to "filter out" or "But at the same time, I need to extract the rows of the item out also, regardless of the GL code.".

In general using the Summarize tool to group by GL code and JE code lets you view all the singular connections from GL code to JE code. With that information you can further manipulate the dataset. Could you explain a bit more what it is that you need?

Cheers

All comments

unknown

Hey @terrellchong!

I'm not too sure what you mean by codes you need to "filter out" or "But at the same time, I need to extract the rows of the item out also, regardless of the GL code.".

Cheers

Christina_H

So you want to remove all your coloured rows? Filter out the yellow ones by GL code, then join the two sides of the filter by JE code to identify other matches.

PorcedanDyedrops

This works! Thanks!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703