Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter or query data while reading data

TJ2
7 - Meteor

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?

2 REPLIES 2
Jonathan-Sherman
15 - Aurora
15 - Aurora

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
7 - Meteor

Thanks, this is it.

Labels