Hi All,
I have two tables. Table 1 contains Investor information and the funds they invested in.
Table 2 is the table I need to update depending on where the fund is invested in Table 1.
I'm been sitting on this for a few days now and I can't think of a way to update Table 2 using a join on column values from Table 1.
Thanks in advance.
Table 1
| Investor | Investment Amount | Fund |
| A | 200 | 1 |
| B | 100 | 4 |
| C | 300 | 5 |
Table 2 (Existing Table)
| Investor | Investment | Fund 1 | Fund 2 | Fund 3 | Fund 4 | Fund 5 |
| A | 200 | 200 | 0 | 0 | 0 | 0 |
| B | 100 | 0 | 0 | 0 | 100 | 0 |
| C | 300 | 0 | 0 | 0 | 0 | 300 |
Unfortunately, I cannot attach anything as Alteryx is tagging my account as spam.
