Interface Tools: filtering date from multiple files

Question

Hello,

I'm working to develop a basic search tool for historical sales data.  My source data is housed in multiple monthly Excel files.  I would like users to select date ranges to query (using the Interface - Date tool), but I'm not sure how to accomplish that without the workflow first taking forever to Union multiple files together.

Is there a way to filter a date range and THEN begin compiling data from that date range?  How can I improve workflow speed?

Suggestions?

skeen503979 · Answer

Thanks, @christine_assaad I'll give that a shot.  I've never used that before, but am generating one now.  So you think that one .YXDB file should be easier to process in my workflow in order to select a date range?

Christine_Assaad · Answer

Hi @skeen503979

What about creating a Master data file - YXDB - that will have the monthly data consolidated? this way you can have a single input that has everything. Hope this helps. Cheers!