Let me explain my requirement clearly...
Filter values and the scenario name will be given in an excel file. And I need to apply those filter for each scnario.
First I'll load the whole data into a qvd file. Then I need to apply the filters for each scenario on that qvd and will load it in a table. So whenever the users select the scenario the values will be filtered out. (Just to avoid selecting the values manually for each scnario during the analysis)
Now the Filter conditions are in the following format
DBTableName.DBFieldName1 like 'abc%' or DBTableName.DBFieldName2 like 'de%'
This filter condition can contain any number of fields.
As I need to apply this formula on top the qvd, I cannot use 'like' function and the above string needs to be converted into
wildmatch(DBTableName.DBFieldName1,'abc*') or wildmatch(DBTableName.DBFieldName2,'de*')