dublicate rows and changing datafields

[Silke]

Dear Alteryx Community,

I´m testing Alteryx to see if it makes sense to replace a lot of Excel work with Alteryx. I´m wondering how I can solve the following step in Alteryx.

I do have certain expenses on a Cost Center in a specific Entity (30). I want to prepare my data that 60% of these expenses stay in this specific Entity (30) and the remaining 40% goes to another Entity (40). 

I have attached the entries as example in Excel as I would normally prepare them. On the Input tab you find the original entries, the Output tab shows the result I´m Looking for.

What workflow do I need to create to get to these final results (in an efficient way)?

Any feedback, help and Solutions are much appreciated!

Thanks a lot in Advance,
Silke

[Jonathan-Sherman · Accepted solution]

Hi @Silke,

That could be achieved by using two formula tools (to edit the values) and union the data back together:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Silke]

Thanks Jonathan. 

Solution worked exactly for what I was looking for.

Best regards,
Silke