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

20180425_232206.png

Join

Accepted answers

LordNeilLord

Hey @mupad2008

I'd go for something like this:

Difference.yxmd

patrick_digan

@mupad2008 The attached may work.

4-28-18.yxmd

All comments

LordNeilLord

Hey @mupad2008

I'd go for something like this:

Difference.yxmd

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 - 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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703