Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Joining 2 excels with different data

jdkatz1
8 - Asteroid

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

 

10 REPLIES 10
Luke_C
17 - Castor

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?

Labels