Forum Discussion
Solved
Lookup data from another table when text exists
Afternoon, I'm trying to work out how I can look up a value from Table A if the text in a column of Table B contains text in a different column in Table A. To give an example of the data: ...
Try removing the each between "NormalisedRoomType" and (rowB) in the Advanced Editor.
Sorry, I misread the question. In your case, I would Split by Delimiter Table B "RoomType", using a space as the delimiter, making sure you choose Split Once, from the end.
Now you can just Left Join Table B to Table A using the new column in Table B and the TextToSearch column in Table A.
--Nate