I've searched this forum but with no result (may be wrong key words used). That's why - the new post.
Situation: There is a main table in external source. In Excel spreadsheet users can specify what kind of values they need to filter from main table. It is very simple if there is a need to specify values of one field in main table. But what if needs are more complicated, e.g. user can specify not only accounts, but also several document types to filter.
In attached example we need to filter from main table transactions with accounts mentioned and with document types, separated by comma (empty cell means all types). I prefer, that subfield function will be used here.
Filtering must be made in script while reloading.
We can't download whole main table, 'cause it is huge, that's why manipulations with WHERE statement are needed