Updated Table used in Existing Merged Query resulting in null values

[rssvlk]

Hello!

I have two tables. Table A is a hosted dataset and has column "id" Table B is a manual table and has columns "IDs" and "Top of Well Elev". At first, I only had information to populate some of the Table B IDs. the rest were filled with place holders like "9999".

Previously I added a merge query based on id to bring in the Top of Well Elev values into Table A. It worked as expected and rows for which I had Top of Well info for were populated in Table A. 

Later, I have addtional info and updated some palceholder IDs with their actual IDs and the Top of Well values. However, the merge query is not pulling in these new values, as seen here:

Even though the Table B has those IDs to merge:

removing the merge query step and redoing it does not help either. The ids are both set to be Text. They have a Many to One realtionship based on ID. Any idea what is going on or what to check? I've tried building a brand new table B from scratch and still get null results upon merging. 

[HotChilli]

Yes, I understand what you want.  I'm just asking for an ID from A and an ID from B which you expect to match but are not.  

[HotChilli]

Can you show us a particular pairing that you expect to match (I can't see any from a brief inspection of the provided photos)?

[rssvlk]

I want Top of Well to be included in Table A, so that I can use it in a calculated column.

Table A

Table B

[Fsciencetech]

Can you please share pbix.

[rssvlk]

https://1drv.ms/u/s!AtBUWtGt4mjx2yRI_Ok6TLpT8DAd?e=kBh3fE

[Fsciencetech]

@rssvlk As I saw, you are using leftouter join and in this case all records are matching from site location table ids to manual table (Well top elevations) IDs. only those records would not be matched because those ids not present in site location.

However if you want to see both the IDs and value from manual table then use fullouter join.

[parry2k · Accepted solution]

@rssvlk means the ids are not matching, maybe there is whitespace, apply clear and trim step before merging and see if it helps.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[rssvlk]

Okay everyone, I figured out that I am a dumdum 😥. I think the original issue was this, I had whitespace. But in trying to fix it, I copied the table wrong and my IDs were messed up. 🙃 Thanks to everyone for trying to help! 

[rssvlk]

Clean and Trim applied to both columns, still not working as expected 😕

Here is some addtioanl screenshot details, amybe someone can spot where I'm going wrong..

Table A

Table B