In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How to Get Max field value of a large dataset without slowing down the workflow

dgaines1972
7 - Meteor

My issue is, I have a database table that contains a field [index number].  This table contains thousands of records and many other fields.  I need to get the max value of just [index number],   Presently, I am using a simple input tool (bringing in all fields and all records in the the table) followed by a  summarize on max value of [index number].  This method works, but it greatly slows down my overall workflow because it took so much processing power to read in the entire table.  Is there a faster way?  Thank you,

2 REPLIES 2
binuacs
21 - Polaris

@dgaines1972 One option connect your database to the input tool and find the max of the index number using the SQL query 

nagakavyasri
12 - Quasar

@dgaines1972 You can sort the [index number] first and then use sample tool to get the maximum value.

Labels
Top Solution Authors