In-Database Median Summarization

Question

I am working on a workflow which requires me to take the median value of data field. This is possible with the Transform>Summarize tool but not avaliable in the In-Database>Summarize In-DB tool.  Due to the size of data I am working with, In-Database calculations will be needed.  Does anyone know a workaround to allow In-DB median summarization calculations?  For note, we are using a Teradata database.

jdunkerley79 · Accepted Answer

I dont know teradata particularly but could you use a in-db formula to add a row number partitioned and sorted in the same way as the summarize you want.

You can then use the summarize in-db to get the maximum row number and then find the median by selecting joining back to half this value.