Hi all, If I want to match the data from "Total" column in "Table A" to the Company Name and have the data populate an empty column in "Final total" under "Table B", how should I do it? Table A and Table B are two separate input datas. I would like the final output to be like Table C. Table A Company NameTotalCompany A1111111Company B 222222Company C333333Company D444444 Table B Company NameFinal totalCompany A Company B Company C Company D Table C Company NameFinal totalCompany A1111111Company B 222222Company C333333Company D444444 Cheers, J

Help - Find replace or join or something else?

Hi all,

If I want to match the data from "Total" column in "Table A" to the Company Name and have the data populate an empty column in "Final total" under "Table B", how should I do it? Table A and Table B are two separate input datas.

I would like the final output to be like Table C.

Table A

Company Name	Total
Company A	1111111
Company B	222222
Company C	333333
Company D	444444

Table B

Company Name	Final total
Company A
Company B
Company C
Company D

Table C

Company Name	Final total
Company A	1111111
Company B	222222
Company C	333333
Company D	444444

Cheers,

Input

Tips and Tricks

Help

Join

Preparation

Interface Tools

Accepted answers

JosephSerpis

Hi @jcsoh I mocked up a few examples on how you can do this. Let me know what you think?

Join_Find_Replace_05072020.yxmd

JosephSerpis

Hi @jcsoh the Join approach that I demonstrated will sort your data into alphabetic or numerical order depending on the data fields/columns you are joining. In your example using a Join tool no matter which way you input your data the output should look like Table C. The Find and Replace approach will respect the order of the data put into the F (Find) Anchor. Therefore if you connected Table B to the F anchor and Table A to R anchor of the Find and Replace tool it will stay in the order of Table B. You can use a Sort tool though after Find and Replace tool to match Table C.

I will add one caveat if you are using Alteryx Designer 2020.2 with the AMP engine turned on then the Join tool approach will not be outputted in alphabetic order and you would need to use a Sort tool afterwards.

All comments

JosephSerpis

Hi @jcsoh I mocked up a few examples on how you can do this. Let me know what you think?

Join_Find_Replace_05072020.yxmd

jcsoh

Thanks @JosephSerpis for the prompt solution! That works. I have another question that is linked to this, I'll post it in a separate discussion post.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703