Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Update column in Table 2 based on column value from Table 1

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

InvestorInvestment AmountFund
A2001
B1004
C3005

 

 

Table 2 (Existing Table)

InvestorInvestmentFund 1Fund 2Fund 3Fund 4Fund 5
A2002000000
B1000001000
C3000000300

 

Unfortunately, I cannot attach anything as Alteryx is tagging my account as spam.

0 REPLIES 0
Labels
Top Solution Authors