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 want Load 4 fields from a resident table. In this table i have ID_Employee, Name Employee, Function, UnityBussiness.
I want load this where ID_Employee must be distinct. Any ideas?
Thanks in advanceBest Regards
May be another way ?
LOAD *, IF(ID = Previous(ID), 0, 1) AS RowNum INLINE [
ID, Name, Function, Unity
1, Bruno, cooker, kitchen
2, Andrew, engineer, company
2, andrew, engineer, company
Where RowNum = 1;
Drop Table Tab;
Load * Inline [
ID, Name, Function,Unity
ID as ID2
Where not Exists(ID2, ID)
DROP Table Source_Temp;
Sorry, is hard for me create examples, but i solved the problem. Thank you
Yes dat was my error Andrew should be equal. But i solved the problem Thank you
I think this should work
where not exists(ID);