Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I add a column to a table that indicates whether a field in one table is found in a different table?

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 NameLogged into the system (yes or no)
Joe Yes
SarahNo
EliseYes

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?

4 Replies
alexpanjhc
Specialist
Specialist

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];

Not applicable
Author

Hi Alex,

Do I enter that in the data load editor?

I'm new to all of this so any help is appreciated!

swuehl
MVP
MVP

Another option could be Exists() function

Exists ‒ QlikView

or even the Lookup() function

LookUp ‒ QlikView

alexpanjhc
Specialist
Specialist

Yes, you put it in the editor,(Ctrl+E)