Dynamic Input Error Message

gavin_data

I am attempting to update an IN statement from a query that executes a SQL statement using the Dynamic Input tool which grabs the inputs from 2 columns in a CSV and am receiving the following error: The file "" has a different schema than the 1st file in the set.

The Dynamic Input tool updates using the "Replace a Specific String" configuration. This is because I want to update the IN statement that exists in the WHERE clause of the main outer query as well as a sub-query, but also so that I can create a concatenated column using the input values. 

It might help to know that when I copy and paste the values from SSMS into a text input, that I don't receive this error. Only problem with this method is that it only works in test scenarios because I'll have too much data to manage a copy and paste without crashing designer. 

mceleavey

Hi @gavin_data ,

Apologies. Save the macro I have attached below to your macros folder. If you don't have one set up, go to Options->User Settings-> Edit User Settings. Click the "Macros" tab. Input the filepath of where you want to store your macros.

Replace your input tool, marked as "CSV Input" with the directory tool, and configure this tool to look into the folder where your csv files are stored:

Then, looking at your original workflow:

replace the first four tools with the following:

Then connect the output with your second data cleansing tool.

This should fix your issue.

If you like, send me your workflow and I'll build it for you.

M.

Import Multiple Schema csv.yxmc