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
Please include the data so we can run your flow - best thing is to Export Workflow under Options and post the .yxzp
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
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!
Screenshots could also try to help