Hello
I have 2 tables:
Table 1 include grocery store names in a city and its addresses:
| Grocery store names | Address |
| Small region 1 Walmarts | Street A 1 |
| 491801 Small region 2 Target | Street B 1 |
Table 2 include small regions and big region names:
| Small Region | Big Region |
| Small region 1 | Big region 1 |
| Small region 2 | Big region 2 |
I want to make a new column in Table 1 that is:
if Table1[Grocery store names] contains Table2[Small Region] then Table1[Address] & Table2[Small Region] & Table2[Big Region]
else Table1[Address]
Sample outcome table:
| Grocery store names | Address | New column |
| Small region 1 Walmarts | Street A 1 | Street A 1 Small region 1 Big Region 1 |
How can I achieve this?
Thank you before hand!
