Forum Discussion

jak8282's avatar
jak8282
Icon for Helper III rankHelper III
3 years ago
Solved

Replicating Qlikview function in Power

Hi,   I have the following in Qlikview   // Test records: if(wildmatch(lower(FIRST_NAME),'*dummy*','*regression*',' test*','test *','*condition*','*invalid*')>0 or wildmatch(lower(LAST_NAME),'*d...
Need Help
  • pratyashasamal's avatar
    pratyashasamal
    3 years ago

    In place of wildcard try to use FIND(), SEARCH(), CONTAINSSTRING(), CONTAINSSTRINGEXACT().
    The Qlik function needs to be rewritten.

     

jak8282's avatar
jak8282
Icon for Helper III rankHelper III
3 years ago

Thanks Pratuashamal , can you use wildcards in those functions?

pratyashasamal's avatar
pratyashasamal
Icon for Memorable Member rankMemorable Member
3 years ago

In place of wildcard try to use FIND(), SEARCH(), CONTAINSSTRING(), CONTAINSSTRINGEXACT().
The Qlik function needs to be rewritten.