merging queries shows 0 matching

[Vos]

Hello all, this is my first time posting here, I am a student and for a project for school I am trying to solve this. I am trying to merge the queries for creating a connection, but it shows 0 matching from the main table, its so weird because when I go to look for a specific projectnumber it is on both sides so I don't get it.

FYI i tryed all types of joines but it still comes with 0 and I deleted duplicates and nulls on the PrProject)Test.  I tried the fuzzy checkmark but it kept loading..

[MFelix]

Hi @Vos 

Are you doing ok or are you only focusing on the result that you have on the window you present? Check if after the ok when you do the expand if the column is null or if you have values.

[MFelix]

Hi @Vos ,

Your information on both the tables seems different since one only shows numbers and the other numbers and letters, but assuming this is because of the number of rows we see in the preview, be sure that both column on the tables you want to merge have the same data type in this case believe it should be text.

[Vos]

@MFelix 

Hi MFelix, they are both Text in type, and yes its correct there are project that start with only numbers, some have P and then numbers example

P1444
PR1444444

PR144-01

Can this naming convention be the cause of it?

[MFelix]

Hi @Vos ,

If the naming convention is the same in both tables everything should work properly, or are you using tables with different namings for the same project?