Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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