Add a column of one table to another table.

[KrishnaChithrathil]

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 B). 

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

Thanks,

Krishna

[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 · Accepted solution]

Hi @KrishnaChithrathil 

Here is an example for you:

[KrishnaChithrathil]

@DavidSkaife 

That was neat. Thanks.