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.
SOLVED

Populate column with values from another sheet based on common values

TaxStudent
5 - Atom

I have one sheet (A) that looks like this:

Country      Year        Income

Argentina    2023      100

Argentina    2024      200

Argentina    2025      300

Australia     2023      100

Australia     2024      200

Australia     2025      300

Belgium      2023      100

Belgium      2024      200

Belgium      2025      300

Etc.

 

And another sheet (B) that looks like this (in its entirety):

Year         Rate

2023        50%

2024        50%

2025        37.5%

 

I'm trying to get a result (C) that looks like this:

Country       Year        Income     Rate

Argentina     2023       100           50%

Argentina     2024       200           50%

Argentina     2025       300           37.5%

Australia      2023       100           50%

Australia      2024       200           50%

Australia      2025       300           37.5%

Belgium       2023       100           50%

Belgium       2024       200           50%

Belgium       2025       300           37.5%

Etc.

 

I can see that what I want to do is get the rates from sheet B to append to the end of sheet A based on the relationship between the years in sheet B and sheet A. But, I cannot think of a tool or combination of tools that can achieve this result.

 

Do you have any ideas?

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@TaxStudent 

We can use the Find and Replace or Join tool for this case.

0311-TaxStudent.PNG

saveeshkumar
9 - Comet

Hi @TaxStudent ,

 

Hope this will help you

 

saveeshkumar_0-1646973326526.png

 

Thanks

 

TaxStudent
5 - Atom

Thank you (谢谢!) both for the responses! I went with Qiu's suggestion using Find and Replace. It took me a few minutes to realize it would only work after I converted the years from doubles to v_strings. Works like a charm, now!

Labels
Top Solution Authors