Column 8 in UNION ALL has incompatible types: DOUBLE, STRING at [24:1]
SELECT
LOCATION,
DEPARTMENT,
MANAGER,
SUPERVISOR,
ASSOCIATE,
FISCAL_DATE,
AUX_NAME,
ACTUAL,
PLANNED,
” “FSCL_YR,
” “FSCL_WK,
” “FSCL_MTH_NM,
” “FSCL_YR_WK,
” “FSCL_DT,
” “ORG_NM,
” “SRMGR_PRSN_NM,
” “DIR_PRSN_NM
FROM analytics-views-thd.CONTACT_CENTERS.CC_ASSOCIATE_AUX_USAGE_UNPIVOT
WHERE FISCAL_DATE >= DATE ‘2024-01-29’
UNION ALL
SELECT
” “LOCATION,
” “DEPARTMENT,
” “MANAGER,
” “SUPERVISOR,
” “ASSOCIATE,
” “FISCAL_DATE,
” “AUX_NAME,
” “ACTUAL,
” “PLANNED,
FSCL_YR,
FSCL_WK,
FSCL_MTH_NM,
FSCL_YR_WK,
FSCL_DT,
ORG_NM,
SRMGR_PRSN_NM,
DIR_PRSN_NM
FROM analytics-views-thd.CONTACT_CENTERS.AGENT_METRICS
WHERE FSCL_YR = 2024
I have cast actual and planned as string and float64 but still getting error
Esty is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
3