read Huge data in Alteryx

[BRRLL99]

Hi

I have 3 different Access Files , each contain around 1,988,826 KB data and in that each file has 3 different tables

my end goal is to combine all 3 files based on field names.

I tried just to combine 3 different files it is taking me more than 40 mins to load the data.

Is there a way where i can insert data and run the entire workflow in less than 5 mins

is it possible to connect In-db tool to Access file ??

Note : i can't connect to SQL database due to internal restrictions

[ChrisTX]

Microsoft Access is not supported for in-database processing.

Can you perform a Join with only 2 tables, then join to the third table?

Documentation:

Start with the help topic for In-Database tools
https://help.alteryx.com/current/en/designer/tools/in-database.html

On this web page:  In-Database Overview
https://help.alteryx.com/current/en/designer/tools/in-database-overview.html#idp323744

under section Supported Databases, Microsoft Access is not listed

Chris

[BRRLL99]

Is there a way to do without using in db tools

[ChrisTX]

Sample input data would help.

Did you see this question:  

Can you perform a Join with only 2 tables, then join to the third table?