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.
Solved! Go to Solution.
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
Thanks for your advice. It is working now.
Please mark it as solution for others.
I'm unable to open a Dynamic Tool due to the following error. I can't figure what I need to manipulate in SQL to get access.
Any guidance will be greatly appreciated.