I have 3 datasets. I have joined dataset ‘A’ and ‘B’ via an inner join to create ‘AB’ data.
‘AB’ dataset consists of 3 fields from ‘A’, and 2 fields from ‘B’.
I now have joined ‘AB’ to dataset ‘C’ with a left join. So i keep everything in ‘C’, and add data where it matches from ‘AB’. All joins have been connected through the field caseID. When creating this new dataset ‘ABC’, it has taken a couple hours to import.
Why has this done this? Do i just need to join the datasets ‘A’ and ‘B’ individually to ‘C’, so i do it in one step. Rather than inner join ‘A’ and ‘B’, and then join this new merged dataset to ‘C’.
See the screenshot below for detail.
I connect B and C via inner join. This forms dataset BC.
Hi @HarveyB-B - Why you are not joining 3 data sets in one data preparation stage so that it will execute as expected. any reason you are creating 2 different data sets.
Hi @HarveyB-B ,
depends!
First as @Sanjeeb2022 said.
Second you are using different kind of data sources?
Third how many data (rows columns) are you query m
BR
Because i wasn’t sure on how to connect it properly in one. I want inner join between B and C, and i want left join for BC to A. How do i do this in one dataset, instead of doing what i did and create them in another, and then add that into the main one?
