Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Error Inserting data that points to a select statement that has columns not in the table

tfranz
6 - Meteoroid

I have a macro that I can run and loads data into a table as needed.  However, when I call that Macro from a workflow, it fails. The input from the workflow to the macro is the same data that I am running the macro by itself. 

 

The error message is 

Data Quality Process (45) Record #1: PostSQLRuleResultsMacro (170): Record #1: Tool #2: Error opening "SELECT "RuleID","RuleRunID","ResultPrimaryKey","AsOfDate","MetricValue","ResultValue","VendorID","ProductID","SourceID","Environment","Input_#3_Environment","Input_#4_Environment","Source_Environment" FROM "DQ_RuleResults"": No Columns Returned.

tfranz_0-1683679184997.png

 

The DQ_RuleResults table does not contain the columns: ,"Environment","Input_#3_Environment","Input_#4_Environment","Source_Environment"

 

Below is the Macro where this is failing. 

tfranz_2-1683679828939.png

 

The data that is being inserted is this  

tfranz_4-1683679987554.png

Please not there are no columns "Environment","Input_#3_Environment","Input_#4_Environment","Source_Environment" in the data being sent to the Output Data tool.

 

Why is there a select that runs that thinks these columns are part of the DQ_RuleResults table when the only columns in the table are the one's listed above from the Select tool.

 

 

3 REPLIES 3
apathetichell
20 - Arcturus

Add a browse tool before the select. Uncheck the "Unknown" box in your select tool. Re-run your workflow and examine the results.

 

Also - can't hurt to ask - what's the config of your action tools in your macro?

tfranz
6 - Meteoroid

Unchecking the Unknown in the Select tool did the trick.  Thank you!

apathetichell
20 - Arcturus

Hi - can you mark my solution as correct? The browse tool was for error checking to see why you are seeing those extra columns.

Labels
Top Solution Authors