Seperating Values by Formula

[selinunlu]

DEAR ALL,

There is the formula  that is a bit confusing. When I put the invoice number to blue column, invoice no is seperated by formulas.

How does it work in Alteryx?

Thanks in advance.

 

[Luke_C · Accepted solution]

Hi @selinunlu 

From your screenshots the below should do the trick:

[selinunlu]

Thanks a lot. It really helped!!