Start Free Trial

Alteryx Designer Desktop Discussions

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

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])

2 REPLIES 2
jrlindem
12 - Quasar

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

dreldrel
9 - Comet

The summarise tool in Alteryx could also help you achieve it. Give it a try

Labels
Top Solution Authors