I have 2 tables. I need to update some of the values in table A based on values in table B. This is part of a bigger function.
Table A has two columns. Source and Tactic.
Table B has one colum. Source
If Table A source = one of the values in Table B, then Tactic should be X else Y.
How to do this? Do I need to iterate through all the values in Table B each time? There are many thousands of rows.
Note: Tables A and B are updated independantly.
Thanks for your help.
Solved! Go to Solution.
Take a look at my article here, it should address your issue.
Take a look at my article here, it should address your issue.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
18 | |
12 | |
2 | |
2 | |
2 |