Im connected to postgres SQL, I have a couple of tables I'd like to use in a project, but when I pull in the two tables I want to use, ive been having problems of things turning to nulls/ losing data. No matter what I do, wether it be relationships or joins there always seems to be a problem and Im stuck! If you have any ideas Id love to hear them.
Hi, @Zane Knopp
I'm not sure if this is what you want, but please check.
Are you having trouble linking the two tables using a relationship or a join?
Do any of the field values actually match?
For example, if one field contains a half-width space, even a slight difference like that can prevent proper referencing.
You might want to check whether the contents of the key fields match in both tables.
Using functions like RIGHT or LEFT to inspect the first or last character could reveal something.
Alternatively, applying the TRIM function to remove extra spaces from the key fields might help. Please consider trying these approaches.
*It might be worth trying to join the two tables using Tableau Prep. You can specify the common fields and easily compare the number of records before and after the join, which is quite useful. Just keep in mind that if the data volume is large, sampling may occur, so a bit of caution is needed. Still, it could be a good idea to give it a try.
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
