Joining between different data sources are possible in global data jobs, e.g.
select *
from <%=DATASOURCE:MDT_100%>.EKPO A
join <%=DATASOURCE:MDT_200%>.EKPO B ON ...
But is it possible to join each other within the scoped data jobs (MDT_100, MDT_200), that means
Scope MDT_100:
select *
from EKPO A
join <%=DATASOURCE:MDT_200%>.EKPO B ON ...
Hi,
no it is not possible to access another scope / schema outside of your current selected scope.
You only have access to different scopes / schemas via global scope.
Only possibility would be to copy the necessary tables from one Data Connection to another by using a transformation in global data jobs as described here: How do I copy a table from one Data Connection to another? (celonis.com)
Thank you very much, it works
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
