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 NameDateNE_RTWK_CNCLM_KKNEM_CNCentral3/31/2020569.988833.4056490.05640.877Central4/30/2020532.12771.8073459.054590.245Central5/31/2020488.146696.7567416.359541.304Central6/30/2020448.527653.7013389.44503.648Central7/31/2020424.079612.0526371.684477.775Central8/31/2020532.12771.8073459.054590.245Central9/30/2020488.146696.7567416.359541.304 Table 2: DateNE_RTCLM_KK4/30/20206.402,1305/31/20207.251,0057/31/20206.90600 Output: NameDateNE_RTWK_CNCLM_KKNEM_CNCentral3/31/2020569.988833.4056490.05640.877Central4/30/20206.40771.80732,130590.245Central5/31/20207.25696.75671,005541.304Central6/30/2020448.527653.7013389.44503.648Central7/31/20206.90612.0526600477.775Central8/31/2020532.12771.8073459.054590.245Central9/30/2020488.146696.7567416.359541.304

Find value by Column and Row and replace it

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

Common Use Cases

Accepted answers

Christine_Assaad

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!

Find value by column and row.yxmd

All comments

Qiu

@Marta12

Hope this is what you need.

0113-Marta13.yxmd

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.

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703