Unable to create a relation between text fields

[Anonymous]

Dear experts,

I am facing a strange issue.

I have 2 excel files as sources. 

- the first one is a the transaction data of sales data. One of the fields (StellinID) is the location of the goods, on 8 characters as a text field

- the second one is the master data of that location (key and description) : the key is a text field, 8 characters long...

When I create the relation 1:N in the relationship manager, it does not complain. But, when trying to get the transaction data by the description of the Stelling (like Sales per stelling name), the relation does not work. It can not find the corresponding values between the tables...

I checked the duplicates, I checked, the lenght, the type...

Any idea where it could come from ?

Thanks

PY

[AiolosZhao]

Hi @Anonymous ,

Could you please show some screenshots of your data, data model, and relationship?

if you can share a pbix with some sample data, that will be better.

Thanks.

Aiolos Zhao

[Anonymous]

Yes I can share a file, but can you let me know how...I don't see the option

Or share your email address.

Thanks a lot for your help! This is really nice to have the ability to share knowledge like that!!

PY

[Pragati11]

Hi @Anonymous ,

You can upload the .pbix file on your drive and create a sharable link. That link can be shared here.

Thanks,

Pragati

[Anonymous]

Let's try that 😉

Text join 

Tell me if it works ( I ma not really used with OneDrive...)

[Pragati11]

Hi @Anonymous ,

It doesn't seem to work. You have to create a free downloadable link.

Thanks,

Pragati

[Anonymous]

Hi

We have some restrictions it looks like...

Try that one 😉

https://drive.google.com/file/d/1v47QNEapAhOfXxhZ44G9JF-J9l93CDPY/view?usp=sharing

[Pragati11]

Hi @Anonymous ,

Your .pbix is downloadable now.

It has got so many file. 

Which 2 datasets are creating relationship issues? Can you please name them here as in your .pbix file?

Thanks,

Pragati

[Anonymous]

Yes sorry, I am jumping between subjects

If you look at Page 1 : the three tables are showing thr Stelling Id 

- From Sales by Day (table on the left)

- From Stelling Master data (table in the middle)

- the effect with the relation ship

If you look at the relationship manager, the relation that I want to work is between Sales by Day table and Stelling_Master_data on field StellingID and StellinID 

So far, I don't see why, the join des not work

[Pragati11 · Accepted solution]

Hi @Anonymous ,

1. You relationship netween the tables "Sales by Day" and "Stelling_Master_data" on column "StellinID" is perfectly right.

2. In you .pbix file on "Page1" tab, 3rd table on the right, you have moved Stellin Id from both the tables but you get blank data for StellinID from "Stelling_Master_data" against the StellinIDs coming from "Sales by Day". The reason for this is, these StellinIds don't exist in your "Stelling_Master_data".

Unique StellinId count in "Stelling_Master_data" = 136

Unique StellinId count in "Sales by Day" = 16

There exist no common "StellinIds" in these two tables.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous]

Hi

Well, ok, the issue is between the keyboard and the chair 😉

Actually, my brain can read VKPSR028 and VPKSR028, and this sthe same...

Thanks for the realignment 😉 And sorry for my dumb question

[Pragati11]

HI @Anonymous ,

No question is a dumb question. 🙂

Keep learning! Keep Exploring New!

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Pragati11]

Hi @Anonymous ,

Can you post some sample data from the both the tables here please?

Thanks,

Pragati