Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Find value by Column and Row and replace it

Marta12
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
Qiu
16 - Nebula

@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!

Marta12
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

 

Marta12
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