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.
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |