Splitting one table into three different ones

[ManuelAmaral]

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

[Emil_Kos]

Hi @ManuelAmaral,

Can you share an example of the data? 

[AngelosPachis]

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