Can i only merge a couple fields from one dataset into another dataset?

Q&A
,
1

I have a dataset which i am using to display data. I have around 5 fields in another dataset which i need to add to to this table to show data on a case. How can i add only specific fields from one dataset, to another, without breaking the datasets.

So it should only merge 5 fields based on the identifier being the caseID.

2

Hi @HarveyB-B,
do have both tables a common column to join?
BR

3

Yes, this being the caseID

4

Then you could join both tables on caseID and include only the 5 (other) fields you want.

5

But how do i select the 5 fields so only they get merged in? I have a couple hundred fields, so is there a way to select include field (5 fields), rather than exclude the other hundred fields?

6

What kind of datasource are using? e.g. in SQL you could define the statement.
Otherwise you have to exclude the n fields somehow.

7

I’d assume SQL, as i am not the one who adds the datasets to quicksight.
image

So i would create a seperate dataset in SQL where it only contains the 5 fields i need, and then merge that into the one i need the fields in?

8

And if so, do i go into here?
image

image
image1463×402 14.6 KB

And enter a query to only retrieve the 5 fields?

9

exactly.

Select 
caseID,
column1,
column2,
column3,
column4,
column5
from your-table

if caseID isnt one of the 5 you need the caseID as well to do the join.