Splitting one table into three different ones

Question

Hello everyone,

I have a table with an account number and an account value and want to split this into 3 different tables.

* One having the account numbers that are unique with the respective values.
* One having the account numbers that are duplicated or triplicated with duplicate/triplicated values.
* One having the account numbers that are duplicated but have different account values.

Can someone help me?

I'm still fresh using alteryx.

Thanks

AngelosPachis · Answer

Hi @ManuelAmaral ,

Speculating how the actual data looks like would influence if the provided solution works or not, but assuming that your data looks something like this:

I've mocked up a workflow that will split them up into 3 tables

Let me know if that works for you, or you have any questions on the workflow.

Regards,

Angelos

example.yxmd

Emil_Kos · Answer

Hi @ManuelAmaral,

Can you share an example of the data?