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.
If you see the below join tool at the right which is being done by employee name. I am having an issue where the 75 from the left side is being joined with every instance of Ray in the right side. Is there a way to have the 75 attached to the one instance and any additional instance a zero or null amount is entered.
Let me clarify so the final dataset as show above I want it to still show both lines but the HRS Balance of 75 needs to be included once. I did try the unique tool but it removed the HRS balance with zeros which I do not want it to do either.
Thanks, I have attached a workflow with two methods to solve what you are trying to do. They have very different results and I think Method 1 is what you want but I thought having the second option could be useful as well.
I also changed the workflow so that the file is on a relative path. So as long as it is in the same folder as the sample data you should be all set to run it.