Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Dynamic Input Error Message

Highlighted
6 - Meteoroid

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. 

 
 

Capture.JPG

Highlighted
Alteryx Certified Partner

hI @gavin_data ,

 

I wrote a tool for this exact issue (attached). Replace the Dynamic Input tool with this and give it a try. This is usually caused because there are hidden characters or merged cells in Excel.

Friends don't let friends Excel.

 

M.

Highlighted
6 - Meteoroid

Thanks for the help!

I'm pretty new with this stuff so sorry if this question seems pretty obvious but im getting the following error after making the adjustments:

Filte: Parse Error at char(1): Unknown variable "FullPath"

 

Capture.JPG

Highlighted
Alteryx Certified Partner

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:

mceleavey_0-1586304326904.png

 

Then, looking at your original workflow:

 

mceleavey_1-1586304532235.png

replace the first four tools with the following:

 

mceleavey_2-1586304632710.png

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.

 

 

Highlighted
6 - Meteoroid

So far I've figured it out with your instructions except for one part.

 

My dynamic input has a SQL query that pulls data from our DB, updating several strings within the query using the CSV files. So what happens to my query, or where do I put it?

Highlighted
Alteryx Certified Partner

I thin I'd need to see what it is you're doing and why you would need a SQL query. The standard answer is replace it with Alteryx.

I'm happy to jump on a call so you can walk me through it if you like?

 

DM me and I'll send you my details.

 

M.

Labels