Lookup values in an array


I’m importing data that has a list of IDS within one cell (e.g.[1,2,3,4])

Is it possible to use the join feature to lookup the IDs from another table and display their values (e.g. [Apples, Pears, Oranges]). I know it’s possible to do for a single item but I haven’t managed to figure out how to do it for arrays


Hey Abrar!

You will need to get those arrays broken out into new rows to make the join work. I would do the following:

  1. Use a Find Replace to replace the [ and the ] with blanks, and then
  2. Use a Column Split to split the list column into new ROWS, using the comma as the split delimiter.

Then you can Join as you normally would!

1 Like