Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

Update existing column value based on custom column

I have table A with the column City.  I have a custom column in this table which basically does search in table B city column and if it finds it put 'Found" in that column.  I would like to update th...
Need Help
  • FreemanZ's avatar
    FreemanZ
    2 years ago

    hi stribor45 ,

     

    you can capitalize or proper both columns, before FindTex comparison. 

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
2 years ago

hi stribor45 ,

 

not sure if i fully get you, try to plot a table visual with call id colum, city column and a measure like:

Status = 
IF(
    MAX(TableA[City]) IN VALUES(TableB[City]),
    "Found!!!", "NA"
)

 

it worked like:

 

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

Ahh. I see what you mean now. Thank you. This works fine but when I was posting this I posted a very simplified example so it is easier to communicate. What I am trying to do is a little bit more complex as I have to match other values. Table A and B also have State and ZIP codes as well so those need to match as well. Sorry, it was my error since I simplified the example for better understanding. My apologies.

 

As an example for each row in Table A I have to find if there is a matching row in Table B that has the same column values