Alteryx designer Discussions

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

Data import from multiple excel file with specific format

Highlighted
Alteryx
Alteryx

The join tool is trying to join "Personnel Number" to "Personnel no" and it's not seeing "Personnel no"  Now both of the files use the name "Personnel Number". 

Highlighted
8 - Asteroid

Hi @TonyA , I've tried to change input 2 to "Personnel no" and run the workflow. However, it is still picking up only one record for the output instead of the 200 records I have on my 2nd input file.

Highlighted
Alteryx
Alteryx

You're going to need to debug the data. If the column names are matching and you are getting some row matches then you're going to need to look at the mismatching values and figure out what is going on. This is not something we can do in an online message thread. You're going to need to find someone local who can help. If you aren't already working with a partner, I would suggest you either find someone within your company or see if the Alteryx sales team assigned to your company can suggest a local partner.

Labels