Hi,
Can anyone assist me with this problem I'm having? I've created a simplfied generic version of what I'm looking to achieve but have been unsuccessful with lookup columns (probably i'm doing something wrong with it).
One table has these fields-
Letter - A, B, C, D, E
Val - 10, 20, 30, 40 ,50
Second table has-
Letter - A, C, E
Val - 10, 30, 50
How do I obtain the letters B and D to show that the data for this was not loaded in the second table
? Hope this is clear on what I'm trying to achieve.
Can anyone assist me with this problem I'm having? I've created a simplfied generic version of what I'm looking to achieve but have been unsuccessful with lookup columns (probably i'm doing something wrong with it).
One table has these fields-
Letter - A, B, C, D, E
Val - 10, 20, 30, 40 ,50
Second table has-
Letter - A, C, E
Val - 10, 30, 50
How do I obtain the letters B and D to show that the data for this was not loaded in the second table
? Hope this is clear on what I'm trying to achieve.
