# Enriching rows using a second table

**URL:** https://community.parabola.io/t/enriching-rows-using-a-second-table/1445
**Category:** Ask a question
**Tags:** Building-Flows
**Created:** [January 4, 2021, 2:40pm UTC](https://community.parabola.io/t/enriching-rows-using-a-second-table/1445 "2021-01-04T14:40:32Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### 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: [January 4, 2021, 2:40pm UTC](https://community.parabola.io/t/enriching-rows-using-a-second-table/1445/1 "2021-01-04T14:40:32Z")

</div>

Hello,

I’m coming back to Parabola after a long time away.  
My request seems really simple but I spent the past hour trying to figure it out.

I have two tables.  
I want to use the second table to enrich the rows of the first one.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/b/bc1c973193db0e4b854ac19b28a43b6e2a7455eb.png)

I managed to combine my table in some useless manner:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/f/feb830de132b9118a6fa2e49e15a675b2d004df3.png)

Then I managed to merge the rows.  
Issue is, the company name is the common reference and if I merge the rows I lose my key value, the job data which ends up being combined.  
Instead of having one row per job, I end up with one row per company (which is logical if I use merge).

What I need is to enrich using a lookup but I can’t figure it out.  
Here is the result I would like:  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/4/4c31c719d8de7b6619bfebdb583742413ccd2974.png)

I give up for now, hoping someone can give me a hint.  
My flow is QzJbXw7D2D in case someone from the team wants to have a look.

Thank you for your help,  
Joachim

---

<div class="post-metadata">

### 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: [January 4, 2021, 3:19pm UTC](https://community.parabola.io/t/enriching-rows-using-a-second-table/1445/2 "2021-01-04T15:19:02Z")

</div>

I solved it and I believe I found a bug.

Even with all proper data cleaning steps, if I try to match comparing URLs instead of regular strings, the combining step fails.  
I double and triple checked, the URLs where identical in both tables and yet the tables didn’t combine.  
I used the company name instead of the linkedin company page and it worked.

---

<div class="post-metadata">

### Author: ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)
#### Post date: [January 4, 2021, 11:35pm UTC](https://community.parabola.io/t/enriching-rows-using-a-second-table/1445/3 "2021-01-04T23:35:12Z")

</div>

Hey @Joachim_Brindeau,

That seems quite unusual that you couldn’t join your tables on a shared value from a URL column.

Could you clarify what you mean when you say comparing URLs doesn’t work, but having them as regular strings do work?

Feel free to reach out to [help@parabola.io](mailto:help@parabola.io) with a link to your flow so we can look into this potential bug.