how to link multiple data sources on a common field

[chris_j_miller]

Hi folks,

I'm working with multiple data sources from excel that have a common field i.e. department.

When a user selects their department I want all data sources filtered by department but kept intact i.e I don't want to merge the data sources.

I've tried using the keep clause and it works fine for 2 data sets when I right join the other data set.

However once I start bringing in the other data sets it looks like outer joins are being completed i.e. departments are listed with nulls if the department doesn't exist in the current data set.

Is there any way to resolve this?

Banging head off desk at the moment as I thought this would work 🙂

Also tried "joining" all table combinations but this just reduced the data sets returned.

Any help would be appreciated.

Regards,

Chris.

[chris_j_miller]

Hi folks, just to help explain my issue I've created a simple app with two worksheets and when I load the data in I'm seeing nulls which I don't want to see plus I want to be able to filter both data sets using the department field.

Thanks,

Chris.

[chris_j_miller]

Hi folks,

See attached the app which demonstrates my question.

REgards,

Chris.