invalid statement unexpected token

sgwong

SQL Studio script are required used in Input Data in Table / Query

Delete DispatchByCustomer
From DispatchByCustomer a
Inner Join OrgDO b
on b.PackNum = a.PackNum

Alteryx prompt error:

Error opening "SELECT * From "Delete DispatchByCustomer

from DispatchByCustomer a

inner join OrgDO b

on b"."PackNum = a"."PackNum": No Collumns Returned.

If add Select * from DispatchByCustomer before Delete ...,

below error

Invalid SELECT statement. Unexpected token "Delete at line 2, pos 1.

Try to place on Post SQL Statement for "Delete .... and Table / Query for "Select ...

It delete entire  DispatchByCustomer entire table information. 

sbansal

Hi,

You can use the Input tool in Alteryx to do this. For this, you need to use :

1. Table and query field to do select of any table

2. Post SQL statement for actually deleting the records as per your query

see attached snapshot

In post SQL statement write your delete query

Delete a
From DispatchByCustomer a
Inner Join OrgDO b
on b.PackNum = a.PackNum

Hope this helps.

thanks,

Sunny