Joining datasets, but only retrieving a few fields from one of the datasets

Q&A
,
1

I have 2 datasets I want to join together (left join the second dataset to the first). I am joining on the case id, but I only want to take a couple fields from the second dataset - prevents joining unnecessary data to reduce size of dataset and faster refresh speed.

I would usually do this beforehand or in the Quick Sight SQL Preview, but i don’t have access to the second dataset directory/location, so unable to do in SQL.

My question is can I left join the second dataset, but only select a couple fields I want to bring over?

EDIT: The dataset joined normally (left join, including all fields) has been like this for the past 15 minutes as the second dataset is pretty large

image
image1990×358 10.9 KB

2

Hi @HarveyB-B
normaly you should be able to exclude any field.

grafik
grafik509×627 30.9 KB

By “pretty large” you mean columns or rows?

BR

3

It has 30,000 rows when I include 4 fields, which has narrowed it down from hundreds of thousands, thanks for the help, this is what I was looking for