Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a situation where I have two tables, and we should not have a common element in both the tables, as the results are ambiguous when we have the ID's as Common. However in one calculation I need to check the common rows for which I need to join them, can we Impose a forced Join on two tables with different names.
Ex: A.EmployeeID = B.EmployeeID
Hi,
I think this can work only in the load script:
JOIN(A) LOAD B.EmployeeID as A.EmployeeID Resident B;
- Ralf
Thanks Ralf,
I tried this, yes it work only in the script level.