Forum Discussion

ChrisO's avatar
ChrisO
Advocate I
10 years ago
Solved

Problem with LOOKUPVALUE not returning all values

Hello,   I have a datamodell from Dynamics CRM. I need to filter for example quotes based on dates and customer. My active relation is between quote and a datetable. No I want to add a custom co...
  • sdjensen's avatar
    sdjensen
    10 years ago

    ChrisO - Do you have a relationship from Angebot[Kunde ID] and Kunde[ID]? Did you make any transformation to any of the 2 columns since loading them from your source - change type etc. ?

sdjensen's avatar
sdjensen
Solution Sage
10 years ago

ChrisO - Do you have a relationship from Angebot[Kunde ID] and Kunde[ID]? Did you make any transformation to any of the 2 columns since loading them from your source - change type etc. ?

ChrisO's avatar
ChrisO
Advocate I
10 years ago

sdjensen Eric_Zhang

 

I just startet to strip down my datamodel to give you the file.

During that process I deleted all relationships in the model.

Now my missing values popped up.

 

I don´t really understand what was wrong but now I know that something in model was wrong.

 

Thank you for your help guys!