Reporting - add basic tables together and report to dynamic path

[Y_B]

Hi,

I have the following two basic tables:

table 1 (output from layout tool)

non trivial	trivial	all
Count	Abs MTM USD	Abs MTM EUR	Count	Abs MTM USD	Abs MTM EUR	Count	Abs MTM USD	Abs MTM EUR
			48	124,863,016	110,244,584	48	124,863,016	110,244,584
8	368,064,750	324,973,291	364	1,353,232,330	1,194,801,634	372	1,721,297,080	1,519,774,925
13	497,732,009	439,459,658	1,479	4,348,007,652	3,838,961,373	1,492	4,845,739,660	4,278,421,032
11	1,507,868,620	1,331,333,763	1,366	682,479,655	602,577,834	1,377	2,190,348,275	1,933,911,597
331	26,431,083,016	23,336,644,019	4,311	7,280,204,273	6,427,868,862	4,642	33,711,287,289	29,764,512,881
4	146,960,702	129,755,167	19,386	352,150,611	310,922,312	19,390	499,111,314	440,677,480
5	184,261,310	162,688,778	92	363,497,510	320,940,765	97	547,758,821	483,629,543
372	29,135,970,407	25,724,854,677	27,046	14,504,435,047	12,806,317,364	27,418	43,640,405,454	38,531,172,041

table 2 (output from table tool)

Type	Path
Subway	.\Output\trades.xlsx|||pivot
Airplane	.\Output\trades.xlsx|||pivot
Train	.\Output\trades.xlsx|||pivot
Boat	.\Output\trades.xlsx|||pivot
Cars	.\Output\trades.xlsx|||pivot
Schools	.\Output\trades.xlsx|||pivot
University	.\Output\trades.xlsx|||pivot
Grand Total	.\Output\trades.xlsx|||pivot

In a first step Table 2 should be added to the left of table 1 with the following result:

	non trivial	trivial	all
LOB	Count	Abs MTM USD	Abs MTM EUR	Count	Abs MTM USD	Abs MTM EUR	Count	Abs MTM USD	Abs MTM EUR
Subway				48	124,863,016	110,244,584	48	124,863,016	110,244,584
Airplane	8	368,064,750	324,973,291	364	1,353,232,330	1,194,801,634	372	1,721,297,080	1,519,774,925
Train	13	497,732,009	439,459,658	1,479	4,348,007,652	3,838,961,373	1,492	4,845,739,660	4,278,421,032
Boat	11	1,507,868,620	1,331,333,763	1,366	682,479,655	602,577,834	1,377	2,190,348,275	1,933,911,597
Cars	331	26,431,083,016	23,336,644,019	4,311	7,280,204,273	6,427,868,862	4,642	33,711,287,289	29,764,512,881
Schools	4	146,960,702	129,755,167	19,386	352,150,611	310,922,312	19,390	499,111,314	440,677,480
University	5	184,261,310	162,688,778	92	363,497,510	320,940,765	97	547,758,821	483,629,543
Grand Total	372	29,135,970,407	25,724,854,677	27,046	14,504,435,047	12,806,317,364	27,418	43,640,405,454	38,531,172,041

In a second step, the result needs to be saved under the path in table 1. Table sizes (number of rows) are dynamic but table 2 will always have one row less than table 1 (always the same fit). Grand Total is always the bottom row.

I know how to solve the dynamic output issue for normal datasets, but I guess here I have to work with a Render tool. Is it even possible to save down the table with the Render tool without the path column?

PS: the table actually looks like this:

The headers of table 1 bugged out when copying to this post. Should stay like this in the results, if possible.

Thanks in advance,

Y_B

[hellyars]

Can you provide a sample workflow?