# Find and replace with value from second table **URL:** \ **Category:** Ask a question\ **Tags:** Building-Flows\ **Created:** [August 11, 2021, 1:11pm UTC](https://community.parabola.io/t/find-and-replace-with-value-from-second-table/1967 "2021-08-11T13:11:21Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\ **Post date:** [August 11, 2021, 1:11pm UTC](https://community.parabola.io/t/find-and-replace-with-value-from-second-table/1967/1 "2021-08-11T13:11:21Z")
Hello! **I have one table with this data:** ![table1](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/2/2007fd5ed491b64ba8d53cb87ddbb09047cc15e3.png) **And the other table has this data:** ![table2](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/1/11c6f7384fafd4a7f80d8a0c37fdb15a0e0b2fb6.png) Please note that there are multiple IDs in one cell separated with “;”. **My request is actually quite simple but I can’t figure it out.** 1. Find match in TABLE1column1 for each ID in TABLE2\_column1 2. Replace ID in TABLE2 with value of TABLE1\_column2 Thank you very much for your help. 🙂 _Joachim_ ---
**Author:** ![Joachim\_Brindeau](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/joachim_brindeau/32/1634_2.png) [@Joachim\_Brindeau](https://community.parabola.io/u/Joachim_Brindeau)\ **Post date:** [August 11, 2021, 2:08pm UTC](https://community.parabola.io/t/find-and-replace-with-value-from-second-table/1967/2 "2021-08-11T14:08:06Z")
Solved it: 1. Name TABLE1\_column1 and TABLE2\_column1 the same. 2. “Split Column” TABLE2\_column1 into rows using “;” as delimitor. 3. Combine table to keep all rows from TABLE2 and base the match on column1 for both tables. 4. Merge duplicate rows ignoring blanks and merging unique values only. Simple enough, it was the split column step I didn’t have.