Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello qlikers 🙂 ,
I'm loading this Excel file
File:
LOAD
"Application Name",
Backup
FROM $(vBackupFilePath)
(ooxml, embedded labels, table is Tabelle1)
WHERE Backup = 1;
I want now all application names from the file table in my WildMatch
let vFlag2=wildmatch('$(vFilePath2)','*Reviews*, *Service*');
I want this dynamic, for example
let vFlag2=wildmatch('$(vFilePath2)','*$(vAppname1)*, '*$(vAppname2)*,...., '*$(vAppnameN)*,);
Is there a option to get this WildMatch dynamic?
Thank you in advance! Looking forward to reading some answers. 🙂
https://community.qlik.com/t5/QlikView-App-Development/Dynamic-Wildmatch-expression/td-p/493726
@Clever_Anjos wrote:Patterns:
LOAD * INLINE [
F1
8989
11231
123123
13123
13
43534
];
List:
LOAD
chr(39)&Concat(F1&'*',chr(39)&','&chr(39))&chr(39) as List
Resident Patterns;
LET Pattern=Peek('List');
Load
WildMatch(yourfield,$(Pattern))
from yourqvd(qvd)
What is vFilePath2 having?
Try to use concatenate with wildmatch this might helps.
https://community.qlik.com/t5/QlikView-App-Development/Dynamic-Wildmatch-expression/td-p/530456
https://community.qlik.com/t5/New-to-QlikView/how-to-use-wildmatch/td-p/1404734
Are you trying to restrict one or few tables based on the fact that Backup = 1? Why not use Where Exists in the future table which is based on your Application Name field?
For example C:/Documents/Qlik/Test , C:/Documents/Qlik/Test/Reviews , ...
Thank you very much!
I need something like that
Hi Steve,
In the end I used some of the suggestions made and the following is my code straight from the application:
CodeList:
LOAD concat(chr(39) & A & '*' & chr(39), ',') As ValueList
FROM
CommodityCodes.xlsx
(ooxml, no labels, table is Sheet1);
Let vSearch = Peek('ValueList',0,'CodeList');
and used vSearch as follows:
LOAD *,
wildmatch(CommodityCode,$(vSearch)) As Match;
Hope this helps
Alexis
But I need the wildmatch in a variable like let Var =wildmatch(...)
How Could I do that? 🙂 Thank you in advance!
Use something like this
var=WildMatch(Concat(ExpressionSelector, ';'), '*Plan*')
Can' you use something like this
File:
LOAD "Application Name",
Backup
FROM $(vBackupFilePath)
(ooxml, embedded labels, table is Tabelle1)
WHERE Backup = 1;
and then this
LOAD *,
If(Exists([Application Name], CommodityCode), -1, 0) as Match;
Thank you in advance! For your help.
Later there is an if instructions.
LET vFlag2 = wildmatch('$(vFilePath2)','*App 1*', '*App 2*',...,'*App N*');
if '$(vFlag2)'= 1 then
...
End if
How could I integrate your code? 🙂
LOAD *,
If(Exists([Application Name], CommodityCode), -1, 0) as Match;
Thank you in advance! Looking forward to hearing some answers!
https://community.qlik.com/t5/QlikView-App-Development/Dynamic-Wildmatch-expression/td-p/493726
@Clever_Anjos wrote:Patterns:
LOAD * INLINE [
F1
8989
11231
123123
13123
13
43534
];
List:
LOAD
chr(39)&Concat(F1&'*',chr(39)&','&chr(39))&chr(39) as List
Resident Patterns;
LET Pattern=Peek('List');
Load
WildMatch(yourfield,$(Pattern))
from yourqvd(qvd)