Alteryx - Dynamic Input Tool

Table of Contents

Dynamic Input of Files: 1:00
Dynamic Input for SQL WHERE Clause: 8:16
Dynamic Input for SQL Stored Procedure Parameter: 14:09

A demo of three different way to use the Dynamic Input Tool: loading data from several files, replacing the WHERE clause of a SQL statement, and as input for a SQL stored procedure parameter. #Alteryx #NPT

[jonathanlee]

Thank you for this video! I often need to grab the same data from different data warehouses due to the frequency at which certain data is updated by certain departments, and dynamic inputs have been a lifesaver for combining that data efficiently. Will definitely be watching more of your Alteryx videos to learn more!

[edwinfcapidos]

Best tutorial I've seen in alteryx. No BS and direct to the point. It's working the first time I've tried it.

[DanielWeikert]

Great work Nathan. Thanks a lot! Really hope to see more. Always looking forward to a new video

[BrianGarside]

Great demonstration of this tool. Love to see the SQL: Spatial Filter as this pertains to a project Im working on.

[KennethBlack]

Nathan,

I've been waiting a long time for a great example of this tool. Thanks for delivering pure awesomeness.

Ken

[minglei]

Thank you Nathan for having a series for Alteryx. I really enjoyed your videos, looking forward to more :)))

[thulasirao]

hi, I was struck in Dynamic input. I removed the replacing value in the first row. After checking your video, I realize that. Thank you. Now it works

[kuntalchowdhury]

Amazing work, thanks for making such great videos

[jasmeetsbhatia]

Great work.. Your knowledge inspires me and the way you teach is perfect.. Keep it up..

[jjuarez]

Hi Nathan, good Job. Thanks for share your knowledge with us. Of course, I would like to see an example of this tool with access databases. Regards.

[mekymoney]

Hi Nathan, thanks for your video, still getting this message when I use the Dynamic tool, "no sheet is specified, you must specify a sheet." is away around it? im trying to combine multi Excel files into one master file. Each file has two similar sheets and named the same thing.

[omkarkommareddi]

Hey Nathan. Thanks. This was really helpful. However, I am restricted to using an ODBC connection. Is there any work-around to use the 'UPDATE WHERE CLAUSE' for the dynamic input with ODBC?

[pradeepkumar-henb]

Hi Nathan, That was quite helpful. could you please make a video on interface section tools. Really hope to see more on every tool.

[Mahabirpanigrahi]

HI, If we need to bring a particular sheet from the file what to do ?
Am trying to do, but the sheet name suffix by '$' sign, which is causing error ? Please advise

[praveengirish]

Does this work for Excels that are not CSV formats as well?

[girimpr]

Can you please show how to load xlsb through dynamic input tool ?

[sirishaalla]

Hi Nathan, I have a scenario where Alteryx should be able to pull previous Day's file, for example today if I run workflow it should directly pick up Day minus 1 day( previous Day's) file as input file on a daily basis? Please help

[TheLazzanova]

Hello Nathan,

Thank you for sharing your knowledge with us. I've learnt a lot from your videos.

I have a question. In my workflow I only use 1 file as an input. But the location of my input file differs each week.
The folders I use contain the Calender Week number in it. So the input file of CW 01 are located in folder named 2018_CW_01.
CW 02 is in folder named 2018_CW_02 etc... These folders are all in the same directory.
Rather than having to manually select the input files each week, I'm looking for a way to make this dynamic.

So is there a way I can actually type in "2018_CW_01" in my workflow, so my workflow automatically selects the input file?

With kind regards,

Önder

[sohammukherjee]

Hello Nathan,
I'm working with a financial data.
That DMS has thousands of datasets. All of them have same kind of data, but the Field names and Positions are different.
I have to create a macro that will take the subtotals from each dataset. Is it possible to create such, through which all of them can run?
I have the column name variations.

[SrinivasaTeja]

Hi Nathan, please make videos on Fuzzy matching, various Macros in alteryx. many thanks!