Run a packaged function in alteryx

[S-9]

Hello everyone. I have a script that uses a packaged function to extract data which I would like to use in Alteryx and automate.

However, I get the error that that package is an invalid identifier. 

Is there any way I can solve this? Thanks

[James_B_Adams]

I can't tell much because the SQL query isn't included (understandably). This is a sql error caused by a being unable to find the alias PACK_ACCT.

For example if you use the below query, by assigning the String "Apple" and not "Apples" the second line will error out because the query can't locate a table called "Apple". 

Select 
Apple.Order_Number
Bananas.Customer_Number
From Table.Orders Apples

LEFT JOIN Table.Customer Bananas ON Apples.Cus_ID=Bananas.Cus_ID

Make sure your SQL is correct first and retry. If you still have issues try making sure the query can run in your regular DB tool first.

If you are able to run it and the error is because of the function you're using then you may have to replicate that function inside of alteryx after pulling in the raw unmodified data without the function.