buy 2 get 1 free sales records

[tsao88]

If a customer orders 2 items, and will get a third item free (the lower priced one of the 2 item purchased), how could I add a third line to those customers invoices by using Alteryx?

[alexnajm · Accepted solution]

It’s possible to do, but it really depends on your data structure.

One option is to use a Generate Rows tool - you’ll need to figure out a way to get the expression to work, but it would theoretically generate needed rows. 

the other option is to cross tab your data, create a column with the lower priced of the two items using a formula of sorts, and transpose it back down. 

good luck!