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


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

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

Something went wrong


Error ID: ###

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



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.