Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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

NameDateNE_RTWK_CNCLM_KKNEM_CN
Central3/31/2020569.988833.4056490.05640.877
Central4/30/2020532.12771.8073459.054590.245
Central5/31/2020488.146696.7567416.359541.304
Central6/30/2020448.527653.7013389.44503.648
Central7/31/2020424.079612.0526371.684477.775
Central8/31/2020532.12771.8073459.054590.245
Central9/30/2020488.146696.7567416.359541.304

 

Table 2:

DateNE_RTCLM_KK
4/30/20206.402,130
5/31/20207.251,005
7/31/20206.90600

 

Output:

NameDateNE_RTWK_CNCLM_KKNEM_CN
Central3/31/2020569.988833.4056490.05640.877
Central4/30/20206.40771.80732,130590.245
Central5/31/20207.25696.75671,005541.304
Central6/30/2020448.527653.7013389.44503.648
Central7/31/20206.90612.0526600477.775
Central8/31/2020532.12771.8073459.054590.245
Central9/30/2020488.146696.7567416.359541.304
15 - Aurora

@Marta12 

Hope this is what you need.

0113-Marta12.PNG

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

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.

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!

 

christine_assaad_0-1610555247390.png

 

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