4 Replies Latest reply on Sep 12, 2019 8:27 AM by Vikram Gokhale

    Relatinship between two data sources: Some null values although data exist


      Hi all,


      I have a relationshop between two sources: A SQL Server and Excel File.


      Relationship has been done in field [Client] in both sources and I am putting in [Amount Y] from the SQL Server and [Amount X] from the excel file.


      For some reason, I get null for [Amount Y] (from SQL server) for one client, altough I see in my SQL server database that the client name match the one in the excel file and that there actually is a [Amount Y] for that client.


      Any ideas of why this is happeníng and how one can solve this?


      Cannot share data due to confidentiality but see snipshot for an example