Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two tables:
1) Includes three columns: Employee Name and Personnel Number
2) A data set that contains unique logins to a system - each unique login is marked by Personnel Number
I am trying to create a table like this:
Employee Name | Logged into the system (yes or no) |
---|---|
Joe | Yes |
Sarah | No |
Elise | Yes |
I would like the second column (Logged into the system) to return a "Yes" if the employee's personnel number shows up in the second data set (i.e. if that employee has logged into the system and their employee number shows up in the login data).
In excel I was using this function: =IF(ISNA(VLOOKUP(G1,A:A,1,0)),"No","Yes")
Where G1 was the employee's personnel number and column A was a list of all the personnel numbers who had logged into the system
Is there a way to do this in Qlik?
you can use the second data set by use
loginmaps:
mapping load [personnel number]
'Y'
from [2nd datasets];
loading *,
applymap('longmaps', [personnel number],'N')
from [first table];
Hi Alex,
Do I enter that in the data load editor?
I'm new to all of this so any help is appreciated!
Another option could be Exists() function
or even the Lookup() function
Yes, you put it in the editor,(Ctrl+E)