# How to combine single column from each 2 different datasets(Redshift & Excell)

**URL:** <https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925>\
**Category:** Q&A\
**Tags:** dataset, Business-Intelligence-Engineer, quick-sight\
**Created:** [February 14, 2024, 3:21pm UTC](https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925 "2024-02-14T15:21:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![anno27](https://avatars.discourse-cdn.com/v4/letter/a/ecb155/32.png) [@anno27](https://community.amazonquick.com/u/anno27)\
**Post date:** [February 14, 2024, 3:21pm UTC](https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925/1 "2024-02-14T15:21:52Z")

</div>

I already joined 2 different datasets into single visual tables in the Quicksight,  
column 1 : PPD (integer) (dataset from Redshift)  
column 2 : PPD Excell (integer) (dataset from Excel file)

 ![QS PPD](https://d1wl4jav5dp96l.cloudfront.net/original/3X/3/4/340d7ce36e9fb46c259ab23e51fedf4507e88b82.jpeg)

I try to join those 2 column with integer value into single column(Testing PPD) using concat in the ‘Add Calculated Field’, but the result is String, I could not convert to integer.

is there another way/the easy way to combine those 2 column into single column ?  
Thanks

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [February 14, 2024, 3:36pm UTC](https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925/2 "2024-02-14T15:36:12Z")

</div>

Hi @anno27  
did you try to do parseDeciaml? Maybe in a new field?

> **[parseDecimal - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/parseDecimal-function.html)**
>
> Use the parseDecimal function for calculated fields in Amazon QuickSight.

BR

---

<div class="post-metadata">

**Author:** ![anno27](https://avatars.discourse-cdn.com/v4/letter/a/ecb155/32.png) [@anno27](https://community.amazonquick.com/u/anno27)\
**Post date:** [February 15, 2024, 2:46am UTC](https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925/3 "2024-02-15T02:46:05Z")

</div>

yes it works… I use parseDecimal. Thank you very much

---

<div class="post-metadata">

**Author:** ![anno27](https://avatars.discourse-cdn.com/v4/letter/a/ecb155/32.png) [@anno27](https://community.amazonquick.com/u/anno27)\
**Post date:** [March 16, 2024, 9:38am UTC](https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925/4 "2024-03-16T09:38:54Z")

</div>

sorry I have another question related to parseDecimal,  
if I success to combine those 2 column with concat and convert to integer using parseDecimal in the new field, my question is :

if the value in the column Testing PPD(from data source) will change someday, will the new field update automatically ?, if not how to update it

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [March 16, 2024, 9:25pm UTC](https://community.amazonquick.com/t/how-to-combine-single-column-from-each-2-different-datasets-redshift-excell/25925/5 "2024-03-16T21:25:34Z")

</div>

Yes.

> [@Refreshing on Calculated Field](https://community.amazonquick.com/t/refreshing-on-calculated-field/27379/2):
>
> Hi @anno27 It will change automatically. It’s calculated on runtime for each row . BR