Can I use CASE in aggregate JOIN INDEX?

Analytics

Can I use CASE in aggregate JOIN INDEX?


Hi,

I am trying to create AGGREGATE JOIN INDEX with CASE expression in select and group by clause and its throwing an error.
what should be the work around for this issues?
I am using Teradata 12 version.

Thank you,
Chakri.