Complicated Filtering Criteria From Excel

[Anonymous]

Hi everybody,

I have a good challenge for you 🙂

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.

Obligatory conditions:

1. Filtering must be made in script while reloading.
2. We can't download whole main table, 'cause it is huge, that's why manipulations with WHERE statement are needed

Any ideas?

Rds,
Artjoms

[Anonymous · Accepted solution]

After thinking a while I found one of many ways, how to make my dream come true.

May be somebody can propose more optimal solution?

Rds,
Artjoms

[Anonymous]

Any other suggestions are still welcome!

[Anonymous]

People use to say - nobody can help you better and quicklier than your oneself

I found two solutions for my case. Version with generating WHERE statement works faster with big data sources

Rgd,
AT