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

Question & Answer
, ,
1

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
QS PPD334×593 48.7 KB

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

2

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

BR

3

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

1 Like
4

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

5

Yes.

1 Like