This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have two data sets, each with a list of users.
The first data file is loaded in, and has like 100 users.
The second is loaded in, and has 50 users.
If a user is on both sets, I want to create a new field called UserType and call those users 'B'. If they are only on the original list, then 'A'.
I've done some research and am thinking to use the exists() command but am not sure how to implement this fully.
Sample taken from QV Help Reference.
LOAD * inline [
] (delimiter is '|');
Load * inline [
Load Name as Employee, Address,
IF(Exists(Employee, Name), 'B', 'A') AS GroupType
Drop Tables Employees, Citizens;
View solution in original post