After quite a lot of playing around, I am unsure what use "appendcols" actually is.
The only way this will work is if every single entry in both tables are identical, which is exactly NOT the reason you want to use this.
The results I've seen so far are:
stats1 (today):
X, 1
Y, 2
stats2 (yesterday):
A, 5
B, 3
C,9
appencols produces the following
error, today, yesterday
X, 1, 5
Y, 2, 3
C,,9
which is actually pretty useless. Now, I have yesterday's count of 5 against X, rather than against A where it should be.
I don't quite understand what "appendcols" is good for except putting counts against the wrong fields. It's a bit confusing.
The worst case is that if you have items in a different order, you will get some results against the correct field and some not, just depending on the order they are in.
... View more