Hi all! I have a difficulties with merging data in fields for certain rows, however the case is a little bit different, so I couldn't find appropriate solution for it so far. I need to merge the sum of the data for all shops so it shows as in outcome demonstrated. (The last field is just sum column for example). Thanks everyone for your reply!!! So the data I have: PL LineShop 1Shop 2Shop 3Totals for lines 13-3313 Franchise Costs3,566003,56614 Brand Management Costs1,756001,75615 Pre Operating Expenses000016 Other Income Expense000017 Total Brand Contribution24,592-7,887-2,85113,85418 Cross Brand Management overheads000021 Total Retail Profit before support overheads24,592-7,887-2,85113,85422 Supply Chain overheads3,266003,26623 Total Retail Support Function overheads20,4250020,42524 Total Retail Profit after all Retail overheads901-7,887-2,851-9,837 The outcome should be: I wondered whether that even possible in Alteryx?

Merge data in fields

Hi all!

I have a difficulties with merging data in fields for certain rows, however the case is a little bit different, so I couldn't find appropriate solution for it so far.

I need to merge the sum of the data for all shops so it shows as in outcome demonstrated. (The last field is just sum column for example).

Thanks everyone for your reply!!!

So the data I have:

PL Line	Shop 1	Shop 2	Shop 3	Totals for lines 13-33
13 Franchise Costs	3,566	0	0	3,566
14 Brand Management Costs	1,756	0	0	1,756
15 Pre Operating Expenses	0	0	0	0
16 Other Income Expense	0	0	0	0
17 Total Brand Contribution	24,592	-7,887	-2,851	13,854
18 Cross Brand Management overheads	0	0	0	0
21 Total Retail Profit before support overheads	24,592	-7,887	-2,851	13,854
22 Supply Chain overheads	3,266	0	0	3,266
23 Total Retail Support Function overheads	20,425	0	0	20,425
24 Total Retail Profit after all Retail overheads	901	-7,887	-2,851	-9,837

The outcome should be:

I wondered whether that even possible in Alteryx?

Datasets

Accepted answers

atcodedog05

Hi @Elmin

You can achieve this using merge cells. Sadly its not very straightforward. You need to build different blocks and align as required.

Workflow:

Output:

Hope this helps : )

merge.yxmd

merge.xlsx

All comments

Qiu

@Elmin

Maybe you can do something like this. It is also dynamic for more columns in case.

New Workflow1.yxmd

Elmin

Dear Qiu,

Thanks for your reply, I appreciate it.

However I didn't have difficulties with summarizing the values in data related to the fields.

The thing I need is the table structure to be shown as presented in outcome screenshot.

Thank you!

apathetichell

My brain is a bit fried and there are probably much better/faster ways to get you here but this should do what you want... you'll need to render the output which will overwrite any existing sheets.

shop 1 2 and 3.yxmd

Elmin

apathetichell

Dear, thanks for response, this solution looks like a proper one, but the obstacle is that there are to be 3 separate fields for [Shop 1], [Shop 2], [Shop 3], but with common merged value as in [TOTALS] field. In xlsx it should look like as below:

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703