AS Coach 
-
Re: Removing duplicate from group by strings separated by comma
Yes, with the GROUP_CONCAT function you can insert an ORDER BY clause. SELECT... FROM... WHERE... GROUP BY... ORDER BY GROUP_CONCAT(DISTINCT...)1 -
Re: Removing duplicate from group by strings separated by comma
That would also work to have separate query step to sort the data by the independent mix values before the aggregation. I think in your query you'd have something like ,GROUP_CONCAT(DISTINCT `pr…1 -
Re: Removing duplicate from group by strings separated by comma
I'd try this first since you want to sum price and quantity by the ordered, grouped pricecatweb string: SELECT `date` ,`ordernumber` ,SUM(`price`) as 'Total Retail' ,SUM(`qtyordered`) …1 -
Re: Average run time of a redshift data flow on large dataset
You reference a dataset of 123 columns and a million rows, but a table like this isn't mentioned in the query. Those three tables are all different sizes. Where does this first dataset come in t…1 -
Re: Calculate and Display Churn
Yeah, what we did was we created a dataflow that takes a list of all customers whether they've ordered or not. Onto that transform we then join actual sales data and have a series of columns wit…1
