2 Replies Latest reply: Oct 4, 2017 2:29 PM by Ajinkya Bhonsle RSS

    Lookup function not working

    Ajinkya Bhonsle

      Hi Everyone,

       

      I have a lookup function that does not seem to be working. I am pulling the data from salesforce for Task and User objects:

      Below is the script:

       

      Task:

      LOAD

          Id as "TaskID",

          RecordTypeId,

         OwnerId as "Task Owner ID",

          //AccountId as "Account ID",

          Subject as "Deal Support Type",

          ActivityDate,

          WhatId as "Opportunity ID",

          if(Len(Trim("WhatId"))>0,1,0) as "DealSupportflag",

           Status,

          Priority,

          CreatedById,

          LastModifiedById,

          CreatedDate,

          Date(CreatedDate) as "Task Created Date",

          Year([CreatedDate])& Dual('Q' & Ceil(Month([CreatedDate])/3), Ceil(Month([CreatedDate])/3)) as "Task Created Quarter",

          //OwnerId,

          Description as "Task Description",

          Lookup('Name','OwnerId',[OwnerId],'Owner') as "Task Assigned Name"

          FROM [lib://Salesforce QVD/Task.qvd]

       

      Owner:
      LOAD
          Id as OwnerId,
          Username,
          User_Theater__c as "User Theater",
          User_Theater__c as "Theater",
          UPPER(User_Theater__c) as "USERTHEATER",
          User_Sales_Region__c as "User Sales Region",
          User_Sales_Sub_Region__c as "User Sales Sub-Region",
          User_Sales_Group__c as "User Sales Group",
           Name,
         FROM [lib://Salesforce QVD/user.qvd]

       

      When I try to pull the "Task Assigned Name" field in my dashboard, it does not return any data(names of the Task assigned to). Where am I going wrong?

       

      Can you help!