Displaying 1 result from an estimated 1 matches for "totalvolum".
Did you mean:
totalvolume
2010 Nov 15
1
Aggregate on identical link attributes
...9,000 records the process runs for over an hour. I know there is a more
efficient way of doing this. I want to Sum the below data's volumes where
FNODE and TNODE match,
i.e. FNODE=1 and TNODE =20 -> Volume=100 ,
FNODE=20 and TNODE =1 -> Volume=100
These should be aggregated toTotalVolume= 200.
Also, there are some link without partner links(see record 21 in test data).
This record should not be summed with another link since there isnt a
compliment to sum with.
Thanks in advance.
-JR
#Create test data
TNode<-c(1:20,21)
FNode<-c(rev(1:20),22)
Volume<-c(rep(100...