Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to understand the following functions
1. Like
2. match
3. Mixmatch
4.Wildmatch
Edit Script:
[Table1]:
Load * INLINE [
ID, Name, Dept
1,AAA,D1
2,BBB,D2
3,CCC,D3
4,BBB,D4
]
Assume now i have loaded this table "Table1"
I would require to create another table from 'table1' where the field "name" has the letter 'b' or letter 'c'
## This works##
[Like_Example]:
Load
ID as newID,
Name as newname,
Dept as newdept
Resident [Table1]
where
Name like ('*a*')
## THIS DOESNT WORKS##
[Like_Example]:
Load
ID as newID,
Name as newname,
Dept as newdept
Resident [Table1]
where
Name like ('*a*', '*c*')
If i need to search for both 'a' and 'c', then what is that i should be using?
How to use Match, Mixmatch and Wildmatch with the following example instead of like.
Can someone please help me in understanding this.
Thanks
Sarathi
follow http://qlikshare.com/
all the function were demostrated with small examples
Dear sarathi,
in simple terms:
Match is use insted of writing multiple where conditions or if conditions
for example:
where product='a' and product ='b' and product='c';
by using match we can write like
match(product,a,b,c)
in the same way
wild match is to use match with wild characters %
and mix match is case insensitive
and like is instead of multiple where its same as match.