Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error When Trying to Load Visual Query Builder

latimo1
7 - Meteor

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.

0 REPLIES 0
Labels