Add a column of one table to another table.

Hello Community!

I have to compare 2 tables. Table A & Table B.

Need to check if all Order ids in Table A is present in the Table B. If present, take the matching Product Category from Table B, and add another column in Table A as Product Category (Populate Table A with one more column Product Category, which is from Table .

For unmatched order id, populate Product Category as N/A.

Thanks,

Krishna

Workflow

Developer

Developer Tools

Input

Error Message

Custom Tools

Connectors

Best Practices

Bug

Accepted answers

davidskaife

Hi @KrishnaChithrathil

Here is an example for you:

Join.yxmd

All comments

NataliaElias

Hi,

You can use the 'Find Replace' Tool with the following settings (Make sure your Order ID column is a string):

Unmatched items will have a null product category. You can use a formula tool to replace null rows with N/A.

Best,

Natalia

davidskaife

Hi @KrishnaChithrathil

Here is an example for you:

Join.yxmd

KrishnaChithrathil

@davidskaife

That was neat. Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703