@DaniBoy, any idea how can we achieve this?
Hi DMJerry, I am not sure whether this would help or not - but eh, worth a shot. You may be able to use the SPLIT_PART function in RedShift SQL transform if number of 'selling seasons' are fixed. And then too, it will split in columns rather than rows - but you can than later transform it easily. Code Snippet: SELECT…
I had similar issue, however I have a crosstab sumo card instead. And couldn't find easily how to create a calculated field in there (possibly lack of my knowledge with the tool) neither a way to create a crosstab in analyzer. So, here's what I did - * created a calculated field in analyzer, * in the calculated field,…