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

    Excel Join

    Aaron Evans



      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?