Append columns to the DataSet by sum the logic from corresponding columns

[187]

Hi Alteryx engineer, i have data set like below 

key	USD_DIV_1	USD_DIV_2	ROC_D
APAC	1.000000	2.000000	3
EURO	4	5	22

AND I have lookup table like below

KEY	LOOKUP
DIV RATE	DIV
ROC RATE	ROC

I want to get below results, which means I read data from lookup table and append the column to the dataset and it is value set by the rules which is get lookup value from lookup table for example DIV RATE is DIV then I sum the value from original dataset for those columns contains "DIV" , and do the same logic for ROC RATE

key	USD_DIV_1	USD_DIV_2	ROC_D	DIV RATE	ROC RATE
APAC	1.000000	2.000000	3	3	3
EURO	4	5	22	9	22

[ShankerV]

Hi @187 

I think this post is duplicated, the same has been addressed by @FinnCharlton and myself in the below post.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Append-columns-to-the-DataSet-by-sum-t...

Many thanks

Shanker V