# Alteryx Designer Discussions

SOLVED

## Find value by Column and Row and replace it

7 - Meteor

Hi,

I'm a beginner with Alteryx and need your help.

I need to replace some values from Table1 with values from Table2 according to correct Column and correct Row(Data) . I will be grateful for any tips how to start with this task.

Table 1

 Name Date NE_RT WK_CN CLM_KK NEM_CN Central 3/31/2020 569.988 833.4056 490.05 640.877 Central 4/30/2020 532.12 771.8073 459.054 590.245 Central 5/31/2020 488.146 696.7567 416.359 541.304 Central 6/30/2020 448.527 653.7013 389.44 503.648 Central 7/31/2020 424.079 612.0526 371.684 477.775 Central 8/31/2020 532.12 771.8073 459.054 590.245 Central 9/30/2020 488.146 696.7567 416.359 541.304

Table 2:

 Date NE_RT CLM_KK 4/30/2020 6.40 2,130 5/31/2020 7.25 1,005 7/31/2020 6.90 600

Output:

 Name Date NE_RT WK_CN CLM_KK NEM_CN Central 3/31/2020 569.988 833.4056 490.05 640.877 Central 4/30/2020 6.40 771.8073 2,130 590.245 Central 5/31/2020 7.25 696.7567 1,005 541.304 Central 6/30/2020 448.527 653.7013 389.44 503.648 Central 7/31/2020 6.90 612.0526 600 477.775 Central 8/31/2020 532.12 771.8073 459.054 590.245 Central 9/30/2020 488.146 696.7567 416.359 541.304
15 - Aurora

Hope this is what you need.

Alteryx

Hi @Marta12

Would you mind explaining the logic for 5/31/2020 date to show different amounts on 3rd record of your desired output but not the first one? I also noticed that in the second table, you have 7/30 date but the data are shown next to the 7/31 of the desired output.

How are you linking the 2 tables? Thanks!

7 - Meteor

You are right there was the typo, first date in data should be 3/31/2020 and in table 2 -7/31.

So linking should be done via data and column names.

Alteryx

Thanks for the clarifications @Marta12 . Just wanted to be sure I have good understanding of your challenge 🙂

Please check the below. Hope it helps. Cheers!

7 - Meteor

Thank you both @Qiu and @christine_assaad. I appreciate your effort, both of the solution worked but as I will work with big dataset I think Christine solution will be more sufficient in my case.

Labels