Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaidan_as
Creator
Creator

Error Using Match Function When Load Data

Hello Experts,
So as i mention in the subject, I want to load data from load editor and I want filter the data using Where and Match Function.
So the error and my code is like this 

Zaidan_as_0-1647393860668.png

as you can see, the error stated that the first parameter of Match Function is wrong. But as I know when I read this article https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona... the first parameter is the column name. So how can I fixed this ? 

Labels (4)
1 Solution

Accepted Solutions
Zaidan_as
Creator
Creator
Author

I already found the solutions, just change the [field] to "field" in the first parameter. 
So this is the script 
Where MATCH("Agent Group Name",'SBM Apps team','SCC Apps Team','SPL Apps Team','SSIP Apps Team') > 0;

View solution in original post

1 Reply
Zaidan_as
Creator
Creator
Author

I already found the solutions, just change the [field] to "field" in the first parameter. 
So this is the script 
Where MATCH("Agent Group Name",'SBM Apps team','SCC Apps Team','SPL Apps Team','SSIP Apps Team') > 0;