Discussion Board for collaboration related to QlikView App Development.
I have qvd with rows contained of 4 fields : A,B,C,D.
In case when there is more than one row where A, B,C the same but D is different, I need to take only one random row.
row 1 :
a b c d1
a b c d2
The expected result :
Go to Solution.
Please find the script below
Table1:Load * Inline [EmpId, EmpName, Country, Sal
1, ABC, UK, 12
1, ABC, UK, 13];
EmpId&'-'&EmpName&'-'&Country AS %Key,Sal AS %Val
ApplyMap('Mapping_Table',EmpId&'-'&EmpName&'-'&Country,'NA') AS Sal
Drop Table Table1;
Let me know in case it is not your requirement
You can use Applymap function in this case supposse you have table like below
EmpId, EmpName, Country, Sal
1, ABC, UK, 13
You can use mapping table like
EmpId&'-'EmpName&'-'&Country AS %Key
Sal AS %Val
Resident Table 1;
and then use applymap function in the main table which will only take first occurrence of Sal for common fields