10 Replies Latest reply on Mar 8, 2018 4:41 PM by Zhouyi Zhang

    Excel Join

    Aaron Evans

      Hi,

       

      I have joined my SQL data Table with a static excel file.

       

      In my table I have actual sales values per department and in my excel file I have each departments annual targets, i want to measure actual v target, but if i do not have an actual value for a department in my table then it doesn't pull through that department in my data therefore it doesn't return a target value either.

       

      Any ideas where i am going wrong?

       

      Aaron