hi,
I was not able to run the following query on Qlik. I'm getting "the specifier too long error." Do you think there is another way around this?
thank you for your help
Select *
from
(select UNIQUE_ID, KEY, VALUE
from dwh.2fa_daily_log
)
PIVOT
(
Max(VALUE)
for KEY in
(
CUSTOMER_ID AS CUSTOMER,
GDPR AS GDPR_FLAG,
CALLSEGMENT_START_DATE AS CALL_START,
CALLSEGMENT_END_DATE AS CALL_END,
2FA_SUCCESS AS TWOFA_SUCCESS,
CALL_REASON AS CALL REASON,
LEVEL AS IDENTITY_LEVEL
)
);
