Discussion Board for collaboration on QlikView Scripting.
I have a table that contains employee number and employee name, in some cases the table has 2 records
Employee no EmployeeName
20000005 JOE BLOGS
20000005 joe blogs
I need to return just 1 record
Go to Solution.
May be try using FirstValue or LastValue function in the script:
FirstValue(EmpName) as EmpName
Group By EmpNo;
Then what do you want to do with 2 emplyoee Name
Concat(EmployeeName) as CombineEmployeeName
Try like this if you have more fields in table add remaining field in group by
Firstvalue(Empname) as Empname
Group by Empno;
Capitalize(Trim(Empname)) as Empname
Which one of those two records is 'correct'?
As per you data sample , due to the case miss match its showing as two different records try to convert then to common format using Capitalize() or Upper () function will do that
LOAD [Employee no],
Capitalize([EmployeeName]) as EmployeeName,
//Upper(EmployeeName) as EmployeeName
Good to question to ask