Deleting duplicate if a certain condition met by 1 duplicate already

Hello there,

im totally new to alteryx and i have to do a task at work, I found multple solutions to my problem which were more complex but i couldnt manage to apply them to my problem.

Here is mine. I managed to collect the data from different ressources, cleansed them, changed the format and joined them.

Now i have the following list as example

If a row contains the godname and the area is olymp i want to keep that row. Any other row which contains the godname but has are not olymp should be deleted. The rest should stay untouched even if they are duplicates. The solution should look like this:

Please dont be mad at me because it might be simple. Im new to SQL and alteryx and really tried multiple things like summarize, filter, join and union.

Help

Accepted answers

Luke_C

Hi @noob_noodle

Try this:

Summarize tool to figure out if the god has area populated using the max function
Join the max area back to the dataset
Filter to records where the area is populated AND where no area is populated for any records based on the summarize

Let me know if you have any questions, please accept the solution if you're all set.

New Workflow3.yxmd

All comments

binu_acs

@noob_noodle

noob_noodle

Thank you for the fast reply but its not the solution im seeking.

I can apply a simple filter and also can use the unique tool but thats not help.

I attached the situation and the solution i need as an excel file.

I only want to delete the rows if they are duplicates and the unqiue one contains "olymp" as area. If they are duplicate and the area of the rows are empty i want to keep them.

I just need to delete duplicates if there was same name before and it contained "olymp"

Problem_alteryx.xlsx

Solution alteryx.xlsx

noob_noodle

Anyone any idea ?

Luke_C

Hi @noob_noodle

Try this:

Summarize tool to figure out if the god has area populated using the max function
Join the max area back to the dataset
Filter to records where the area is populated AND where no area is populated for any records based on the summarize

Let me know if you have any questions, please accept the solution if you're all set.

New Workflow3.yxmd

noob_noodle

It’s 11pm. I will try this tomorrow at work. Thank for helping already

noob_noodle

Thank you very much mate ! it worked. I really appreciate it!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703