topic WildMatch in QlikView

WildMatch

satishsure — Wed, 25 Nov 2020 16:16:04 GMT

I have another issue like.I have file name contains "Trans Sales 2016.xlsx". file name has spaces

I need to verify the file name has 2016 or not not.

let vfile2016 = 'Trans Sales 2016.xlsx';

Let vfilename = 'Trans Sales 2016.xlsx';

if( WildMatch(($(vfilename)), $(vfile2016)) >= 1 Then

Concatenate (Data1);

end if

exit SCRIPT;

sunny_talwar — Tue, 13 Jun 2017 18:06:23 GMT

May be this

IF WildMatch('$(vfilename)', '$(vfile2016)') Then

satishsure — Tue, 13 Jun 2017 18:15:49 GMT

Thank you..I have overlooked at variable usage.