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] I try to join those 2 column with integer value into single column(Testing PPD) using concat in …

Hi @anno27 did you try to do parseDeciaml? Maybe in a new field? parseDecimal - Amazon QuickSight Use the parseDecimal function for calculated fields in Amazon QuickSight. BR

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

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 automatica…

Yes. [image] Refreshing on Calculated Field Question & Answer Hi @anno27 It will change automatically. It’s calculated on runtime for each row . BR

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

Q&A

ErikG March 16, 2024, 9:25pm 5

Yes.

Topic		Replies	Views
Append or Concat the Fields Q&A analysis , quick-sight , calculations , Business-Intelligence-Engineer	8	1787	March 27, 2024
Joins in Quicksight Q&A analysis , quick-sight , Business-Intelligence-Engineer	7	193	January 3, 2024
Joining two tables using calculated field Q&A data-source , quick-sight	4	2574	May 2, 2023
Quicksight Custom SQL Q&A data-source , quick-sight	6	1355	July 6, 2023
Display values of 2 fields one below other on the table Q&A quick-sight	5	713	June 13, 2023

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

Related topics