Create a new table based on difference between two tables

[mupad2008]

Hi Members,

I have two tables with same rows and fields, one shows start of day values, and the other close of day. I want to create a new table based on numeric difference between the two, that is change during the day.

Is there a simple way to do this. Any help is greatly appreciated.

Best!

table1 apr may jun
a 12 52 65
b 24 31 71
c 17 28 83

table2 apr may jun
a 19 54 37
b 37 28 54
c 33 27 63
New Table apr may jun
a 7 2 -28
b 13 -3 -17
c 16 -1 -20

[LordNeilLord · Accepted solution]

Hey @mupad2008

I'd go for something like this:

[mupad2008]

Brilliant, job done!

Thanks for the quick reply!

[mupad2008]

Hi Neil,

Ran into another similar issue.

First data set have several records and their monthly values, I need to create a new table where the new records are a  function of previous records.

For example I have Record A and Record B, I need a new table with Record X (which is A - B) for all months.

I could do this based on earlier solution by creating 2 duplicate streams, transposing  and joining them, however under formula I need to use a "WHERE CLAUSE" equivalent to identify A and B, and then write their resultant diff in new table.

What formula expression could be use is this case

Something like this is what I need to do ( [Value] where IN = 'A' - [Right_Value] where IN = 'B')

Thanks!

IN	201804	201805	201806	201807
A	74	52	46	77
B	56	31	70	22
C	71	66	32	52
D	20	25	36	66
E	57	42	65	40
OUT	201804	201805	201806	201807
A-B	18	21	-24	55
C-(0.8D)	55	46	3.2	-0.8
D+E	77	67	101	106

[patrick_digan · Accepted solution]

@mupad2008 The attached may work. 

[mupad2008]

Hi Patrick, thanks for the fix. works perfectly in actual case.

Best!