Find value by Column and Row and replace it

[Marta12]

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

[Qiu]

@Marta12 

Hope this is what you need.

[christine_assaad]

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!

[Marta12]

Hi @christine_assaad , 

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.

[christine_assaad · Accepted solution]

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!

[Marta12]

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.