This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
thanks for the reply. I tried your method but my data set has duplicates emp id which for reason is causing an Cartesian join .
how can i avoid that.
or let me rephrase my problem.. Basically some emp if will have location null . however their manager will always have a location populated. so where ever an emp has null location, i want it to search the manager's location and input that value. so for emp 123, it should search manager 444's location which is Austin. Similarly , for 544 it should input NY.
I think using my previous solution should still work. I would just utilize the new "Manager Location" field to populate the Null Employee locations. Just use a Formula tool to update the Location field with the following:
IF IsNull([Location]) Then [Manager Location]
As far as the duplicates go I would use a unique tool on the manager side data stream before the join.