Error When Trying to Load Visual Query Builder

latimo1 — Wed, 23 Nov 2022 14:54:33 GMT

SQL:

select SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ERROR_MESSAGE,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_DATE,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".DOCUMENT_NUMBER,
SAPHANADB.LIKP.VBELN,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_TIME,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".STATUS,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".MANDT,
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ZPARAMETER
from SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw"
inner join SAPHANADB.LIKP on
Right(SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".DOCUMENT_NUMBER,6)
=
Right(SAPHANADB.LIKP.VBELN ,6)
where SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ERROR_MESSAGE not Like '%Error {40%'
and
SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_DATE >= '20221123'
--and
--SAPHANADB."ZCL_SD012_SALESORDERLIST_RETRY=>ZTSD_SF_ERROR#covw".ISSUE_TIME > '152059'

Query works fine. Try to go to Visual Query Builder and get Invalid SELECT Statement. Unexpected Token "Right" as line 11 pos 1.

topic Error When Trying to Load Visual Query Builder in Alteryx Designer Desktop Discussions

Error When Trying to Load Visual Query Builder