Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

combining databases from the same excel spreadsheet and join with another database

bryan06
7 - Meteor

So I am trying to merge all these tables by a common field but i keep getting lots of null column when their should be the data that is linking them in their im not sure why this is the case

4 REPLIES 4
alexnajm
17 - Castor
17 - Castor

Please include the data so we can run your flow - best thing is to Export Workflow under Options and post the .yxzp

bryan06
7 - Meteor

sadly i am unable to share the workflow with data in it as it is confidential i was just looking for ideas or any improvements

alexnajm
17 - Castor
17 - Castor

Without knowing the actual data, it'll be hard to advise. But check your data before each anchor of your join to see if you are dealing with nulls properly!

alexnajm
17 - Castor
17 - Castor

Screenshots could also try to help

Labels