Joining 2 excels with different data

[jdkatz1]

Hello, when i join 2 excels, the data output is missing certain items. i joined with specific fields (company, fund, deal code). Not sure why the inputs are correct but the output is wrong. 

Excel 1: 374 investments

Excel 2: 411 investments 

Output: 305

[Luke_C · Accepted solution]

Hi @jdkatz1 

Manually should give you full flexibility to line up the columns as you need. Without more information it's not possible to help further. Can you share the workflow with sample data that shows the issue you're having, along with your desired output?