Combine Tables based on Contains match

Hi @Annika_Cederblad – yes, you’re understanding that method correctly and trying that one out was a good place to start. You’re really close here. The step Split column should be what you’re looking for. Try building that flow with the following steps:

  • Two import steps
  • One Split column step
  • One Combine tables step




The one thing to note is when using this Split column step, be sure to include the space after the comma that separates your multi-item row lines. Otherwise it won’t match the row values of something like " banana" to “banana” in the following Combine tables step. :slightly_smiling_face:

1 Like