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?
