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

[tfranz]

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.

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. 

The data that is being inserted is this  

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.

[apathetichell · Accepted solution]

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 · Accepted solution]

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

[apathetichell]

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