Split Data

Question

I have a list of SKUs and their associated revenue - one of these SKUs I'd like to split into 4 *new* SKUs whose total sums to the value of the original SKU; see the screenshot below, highlighted in yellow.

The splitting of SKUs isn't conditional on any other field. I was envisioning I could write a formula or sorts where, for example

IF [SKU] = IST1 THEN [Revenue] * 0.25 (IST1-A)

ELSEIF [SKU] = ISTS1 THEN [Revenue] * 0.5 (IST1-B)

However that doesn't quite work. Any ideas?

Original Table

Desired Table

IraWatt · Accepted Answer

Hey @spencd2,

Here is one setup to generate more rows dynamically from the original data:

Though typically what you would do is just have a separate table with the new values and join them to the original table like this:

See both examples attached.

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

IraWatt · Accepted Answer

@spencd2 ah no worries! 😄 If this will be a common case where you have to select a few SKU's and split them I would recommend putting the first approach into a macro.

If you want to learn more about Macros the community has some really quick interactive videos on getting to grips with them here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Macros

If the top approach solves your problem feel free to give it a green tick 😄