我怎么能在Qlikview做这件事？

Question

我有一个"All_Data“表，其中包含一个”人力资源管理器“列，它包含”员工名称“。我需要获得执行而不是的行来完成以下的连接(即连接表中缺少的行)。

HR_Manager:
Load [HR Manager] as [HR Full Name]
Resident All_Data;

inner Join(HR_Manager)
Load [Full Name] as [HR Full Name]
Resident All_Data;

有人知道我在Qlikview怎么做吗？

特克斯岛

Answer 1

你比我早了1分钟，但你确实忘记了最后的分号;)

HR_Manager:
Load [HR Manager] as [HR Full Name]
Resident All_Data;

inner Join(HR_Manager)
Load [Full Name] as [HR Full Name]
Resident All_Data;

AllTheOthers:

Load [Full Name] as [Employee Name]
resident All_Data
where not exists ([Full Name]);

如果这不是你想要的，下面的方法可能会奏效

HR_Manager:
Load [HR Manager] as [HR Managers that are not employees]
Resident All_Data
Where not exists ([HR Manager],[Full Name]);

这将创建人力资源管理器字段中存在但未出现在全名字段中的所有人员的表。

希望这能帮上忙

詹姆斯。

Answer 2

我认为全名是您在文本中提到的“员工姓名”字段。

这就是你想表达的吗？：

New_Table:
Load [HR Manager] as [HR Full Name]
Resident All_Data
Where [HR Manager] <> [Full Name];

干杯，西蒙

Answer 3

HR_Manager:
Load [HR Manager] as [HR Full Name]
Resident All_Data;

inner Join(HR_Manager)
Load [Full Name] as [HR Full Name]
Resident All_Data;

AllTheOthers:

Load [Full Name] as [Employee Name]
resident All_Data
where not exists ([Full Name])