Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apologies if this question was asked before.
I am struggling find resources as to how asterisk (*) operator works in a set expression. E.g.:
=sum( {<QPermID={"AM0425_R*"}, any_col)
From regex and most other languages i know * stands for any character. Is this the case here?
Yes.
The asterisk means sometimes that you can fill up with a random character the field you want. And 'ALL'
Like the examples below:
Supply:
Load * Inline
Factory,
Order,
Adress,
Country
From Lib [my_files/supply*.qvd] (qvd);
It will consider any letter after supply to load the file you want. The condition you order was just the file name starting with 'supply'.
or maybe
Supply:
Load *
From Lib [my_files/supply*.qvd] (qvd);
It will load all the fields of the file you choose!
Am i being clear? Guess not, but i tried my best.
Your expression means
sum everything that QpermitId starts with AM0425_R