Filter or query data while reading data

[TJ2]

I have very large Alteryx Database files that I need a specific information. Typically, bring in the data via input tool then use combination of filter and join tools to get to what is needed. Is it possible to this while the database file is being read?

[Jonathan-Sherman · Accepted solution]

Hi @TJ2,

Perhaps have a think about using a calgary database file (CYDB) which function in essence like YXDB's but allow you to create indexes to query against so you don't need to read in the whole file before filtering.

Some resources to get you started, there's some great videos on community by @ChristineB amongst others:

https://community.alteryx.com/t5/Videos/Calgary-Databases/td-p/173061

https://community.alteryx.com/t5/Videos/Calgary-Databases/td-p/351882

Hope this helps!

Kind regards,

Jonathan

[TJ2]

Thanks, this is it.