Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Using In-DB to Solve MIN

michael_franz
8 - Asteroid

 

Here is the Min formula I'm using outside of IN-DB. Trying to convert. Process is taking way too long,.... Hours.....

 

 

 

 

Min([#1 Min Eff Date],[#2 Min Eff Date],[#3 Min Eff Date],[#4 Min Eff Date],[#5 Min Eff Date],[#6 Min Eff Date],[#7 Min Eff Date])

1 REPLY 1
jrlindem
11 - Bolide

I realize transpose / crosstab are not in the In-DB tools, but could you use SQL to handle your pivot / un-pivot and modify the data to allow for the use of the Summarize-In-DB tool and then process the MIN() vertically instead of horizontally?  Most database engines do better with tall, skinny data tables rather than wide.

 

But regarding your example, there shouldn't be a reason for this length of processing.  I'm guessing you have a memory leak somewhere or the database isn't allowing for the processing of that many fields against the function for however many rows of data you have...

Sorry I couldn't be more direct in answering, but wanted to get some alternative thoughts going for you.  -Jay

Labels
Top Solution Authors