swingler
asked on
Compare two Crosstabs
I need to do a field by field comparison on the result of a crosstab query and a table.
Table 1 contains a list of datapoints that I've collected and for each ID if the data was collected i've denoted it w/ a 1.
Table 2 contains a list of datapoints that has been processed and in table 2 processed data is also denoted w/ a 1.
Table 3 needs to contain hits (a 1) for each datapoint that has been collected but has not been processed in essence creating a to do list
for each ID by datapoint
Sample Data:
table 1
ID dp1 dp2 dp3 dp4 dp5
1 0 1 0 1 1
2 0 0 1 0 1
3 1 0 1 1 1
4 0 1 1 1 0
5 1 1 1 0 0
table 2
ID dp1 dp2 dp3 dp4 dp5
1 0 1 0 0 0
2 0 0 1 0 1
3 1 0 1 0 1
4 0 0 0 0 0
5 0 1 0 0 0
table 3
ID dp1 dp2 dp3 dp4 dp5
1 0 0 0 1 1
2 0 0 0 0 0
3 0 0 0 1 0
4 0 1 1 1 0
5 1 0 1 0 0
Table 1 contains a list of datapoints that I've collected and for each ID if the data was collected i've denoted it w/ a 1.
Table 2 contains a list of datapoints that has been processed and in table 2 processed data is also denoted w/ a 1.
Table 3 needs to contain hits (a 1) for each datapoint that has been collected but has not been processed in essence creating a to do list
for each ID by datapoint
Sample Data:
table 1
ID dp1 dp2 dp3 dp4 dp5
1 0 1 0 1 1
2 0 0 1 0 1
3 1 0 1 1 1
4 0 1 1 1 0
5 1 1 1 0 0
table 2
ID dp1 dp2 dp3 dp4 dp5
1 0 1 0 0 0
2 0 0 1 0 1
3 1 0 1 0 1
4 0 0 0 0 0
5 0 1 0 0 0
table 3
ID dp1 dp2 dp3 dp4 dp5
1 0 0 0 1 1
2 0 0 0 0 0
3 0 0 0 1 0
4 0 1 1 1 0
5 1 0 1 0 0
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER