# Dealing wi the Duplicate Data

**URL:** <https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885>\
**Category:** Ask a question\
**Created:** [February 8, 2024, 11:37am UTC](https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885 "2024-02-08T11:37:39Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jailynn\_Robinson](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jailynn\_Robinson](https://community.parabola.io/u/Jailynn_Robinson)\
**Post date:** [February 8, 2024, 11:37am UTC](https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885/1 "2024-02-08T11:37:39Z")

</div>

Hi! I have repeating data in my source data and need to figure out how to not have it included. Below I provided an example of similar data. Currently it adds A to both rows in source 1 and B to both rows in source 2. Is there a way to create a new column with A in source 2 based on 2A12 without the data repeating?  
Ex.  
Source 1  
John Firefighter Q2 2A12 $123  
John Firefighter Q2 2B34 $5689

Source 2  
John Firefighter A  
John Firefighter B

---

<div class="post-metadata">

**Author:** ![Emory\_Stainbrook](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/emory_stainbrook/32/1772_2.png) [@Emory\_Stainbrook](https://community.parabola.io/u/Emory_Stainbrook)\
**Post date:** [February 8, 2024, 10:44pm UTC](https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885/2 "2024-02-08T22:44:23Z")

</div>

Hi @Jailynn_Robinson - Happy to help! Is the additional data from Source 1 all in the same cell or is that data spread across separate columns?

The first thing you’ll want to do is separate out the data that you’ll be comparing from the different sources. If all of the data is formatted similarly, you can do this with an [Extract text step](https://parabola.io/transform/extract-text-from-column). Once you’ve isolated the data that you want to compare, you can use a [Combine tables step](https://parabola.io/transform/combine-tables) to append the data from Source 2 to Source 1.

I hope that helps but let me know if you have any questions!

---

<div class="post-metadata">

**Author:** ![Jailynn\_Robinson](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jailynn\_Robinson](https://community.parabola.io/u/Jailynn_Robinson)\
**Post date:** [February 9, 2024, 10:40pm UTC](https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885/3 "2024-02-09T22:40:08Z")

</div>

So we did extract the data, but then when we use the combine tool it duplicates the data instead of just assigning the 2A or 2B appropriately according to the amount in the worksheet.

---

<div class="post-metadata">

**Author:** ![Emory\_Stainbrook](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/emory_stainbrook/32/1772_2.png) [@Emory\_Stainbrook](https://community.parabola.io/u/Emory_Stainbrook)\
**Post date:** [February 9, 2024, 11:15pm UTC](https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885/4 "2024-02-09T23:15:11Z")

</div>

Hi @Jailynn_Robinson - Happy to take a closer look at that Flow set up! Could you please reach out to [help@parabola.io](mailto:help@parabola.io) and send a link to the Flow where this is happening?

---

<div class="post-metadata">

**Author:** ![Jailynn\_Robinson](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jailynn\_Robinson](https://community.parabola.io/u/Jailynn_Robinson)\
**Post date:** [February 10, 2024, 5:54pm UTC](https://community.parabola.io/t/dealing-wi-the-duplicate-data/2885/5 "2024-02-10T17:54:14Z")

</div>

Ok great! I sent an email last night