SAP Knowledge Base Article - Preview

3228221 - Syntax error occurs for the fields to access table joined using "USING" clause in a transformation script in SAP Signavio Process Intelligence

Symptom

We have transformation scripts as below, but getting error to obtain preview.

[Script]
SELECT table_2.key_A
FROM table_1
INNER JOIN table_2 USING (key_A, key_B)

[Error]
Something went wrong

Error: PREVIEW_FAILED

Error ID: ###

SYNTAX_ERROR: line #:#: Column 'table_2.key_A' cannot be resolved


Read more...

Keywords

Syntax,error,occurs,fields,access,table,joined,USING,clause,transformation,script,SAP,Signavio,Process,Intelligence,process-intelligence,pi,preview,SELECT,INNER, JOIN,Something,went,wrong,PREVIEW_FAILED,SYNTAX_ERROR,Column,resolved,prefix,keys,prestodb,presto , KBA , BPI-SIG-PI-TRA , Transformation (Business Objects / Pipelines) , BPI-SIG-PI-DI , Data Import for SAP Signavio Process Intelligence , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.