Pulling one instance of value

Hi,

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.

Workflow

Datasets

Accepted answers

MichaelLaRose

Hi @mabdulh1 ,

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.

Best,

Michael

sample workflow.yxmd

All comments

MichaelLaRose

Hi @mabdulh1

If I understand correctly,

You are expecting that Ray should only be displayed once in the final dataset with all of the same data listed once.

If that is the case you can put a Unique tool in the Right data workflow in order to limit the data to just the unique list of Employee Names.

Does that make sense?

Best,

Michael

mabdulh1

Hi @MichaelLaRose,

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.

So it would show as

Name HRS Bal.

Ray 75

Ray 0

Ray 0 (if there were more than 2 lines)

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335