Forum Discussion

Icon for Helper II rank

Helper II

6 years ago

Appended query not allowing One-to-One Relationship

Hi, I have two tables that are connected to SAP business warehouse server. These tables have the same fields available and I have joined the two with append query. I have a unique identifier (d...

Icon for Advocate I rank

Advocate I

6 years ago

Are you having issues with a 1-to-1 relationship within a data model? It would help to have a screenshot of the model, to look at existing relationships.

DSmith4
Helper II
6 years ago
Is this helpfu l?

I am creating relationshps between the SAP data tables and the excel files with the comments.
The concat fields contains the unique identifier that does not contain duplicated in either table but it is only seeing it unique in the excel file rather than the appended query. It will only allow many-to-one

Manage RelationshipsCreate RelationshipAppend
- amitchandak
  Super User
  6 years ago
  In the table coming from excel, try: remove blank rows and remove duplicate and then try the same.
  - DSmith4
    Helper II
    6 years ago
    Thank you for your reply, however this did not solve the issue.
    As you can see from the screenshot below, I able to use 1-to-1 relationship with the excel comments file.
- v-juanli-msft
  Community Support
  6 years ago
  Hi DSmith4
  
  By default, the direction for "one to one" relationship should be "both", "single" is not supported.
  
  Best Regards
  Maggie
  Community Support Team _ Maggie Li
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - DSmith4
    Helper II
    6 years ago
    Hello,
    
    Thank you for your message however I tested your suggestion and am still met with error.
    
    Please advise
    
    Thank you