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

    marcus.calamnius

      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

       

      Thanks,

      M