I use wildmatch to filter out the waste line. But I get discrepancies with what I filter in excel with my hands. In the click after filtering
Where not wildmatch(Filed_1,'G*','OPA_A','OPA_R','OPA_PP','D110*') and not WildMatch("Field_2",'WAS*') ------> gives me 165 fretchet lines if i do the same filter in excel file i will get 450K lines
Where did another 300k lines disappear in a qlick ?
