Column Error and Duplicates

KevinQVo

Hi, 

I hope you are all doing well! Can someone please offer me some advisement on this? In the images attached, I tried doing the vlookup method using the tools provided. The output was a duplicate of the input file. In the second image, you can see that it pasted the information below the "null". Is there a way to translate the data, so it can be adjacent with the prior columns? 

Thank you all for your help, and please let me know if I can offer more information! 

-Kevin 

Capture 2.PNG

Capture 3 .PNG

CoG

It does not seem like the Union Tool is in the right place. Just looking at the image, it's hard to tell for sure, but I'll bet those two rows that got pasted below "null" came from the join and everything else came from your input file to the Union Tool via input #1. If you are looking to see what values are shared in common then you want to Union (in this particular case) the 'L' and 'J' outputs of the Join Tool. This is because the 'L' output contains all data from your 'L' input (which in your case is the main input file) that didn't match your criteria, and the 'J' is everything that matches from both the input file and the text input your joining to.

If you still need the formula tool with Today's Date, that can be placed after the 'L' output as well before going into the Union Tool.

Edit: Adding a sample workflow as example, please provide more information about your specific needs if this does not work for you.

Sample Workflow Join and Union.yxmd